using Is Null in procedure

[Rick]

Hi,
I am struggling to find the correct syntaxt to determine
whether or not a field on a form is null or not. I'd like
to put the code on the OnOpen event of a form so when the
form opens, if a particular field or textbox is null, then
another control on the form is not visible. Something
like:
If me.text43 is null then
me.text44.visible = False

The first line is the problem. Also, I'd like to be able
to refer to a control that is on a subfrom that is within
the parent form. I don't know syntax for this either.
Thanks for any help,
-Rick

 

[Cheryl Fischer]

Try this, Rick ...

If IsNull(me.text43) then
' the rest of your code

hth,