using Is Null in procedure

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
Back
Top