Look for record using VBA

[RC-]

Hi all,
I've been going round and round with this. I have an MS Access Form.
On this form there are several text boxes that pull data from my table(s).
The text boxes are hidden on the form. My delima is this, how can I write
code that will look at the hidden text boxes and determine if there is data
contained in the box? What I want to do is have an option change if there
is data in the box(s). This way, the user can click the button to expand
the selection and see the boxes that contain the data.

I'm having a problem with the "Null" value. If there is data in the box,
the code works, but if it's Null, it doesn't work.

Any help would be great!
TIA
RC-

 

[Guest]

As you are looking for text, don't bother dealing with Null. I normally
check that:
Len(txtSomeBox.text) > 0

If it is empty or null or blank, the test fails as it takes the length of
the data to be zero.

 

[RC-]

That works perfectly!

Thanks,
RC-

As you are looking for text, don't bother dealing with Null. I normally
check that:
Len(txtSomeBox.text) > 0

If it is empty or null or blank, the test fails as it takes the length of
the data to be zero.