Visible

[lead 27]

HI Everyone

i have a field in my table (min qty) which needs to be filled in once when entering a new record but I dont want to show it on the form all the time. How can I have it so that when the ref number is blank the field is visible and once information has been entered it is invisible? I have tried this on the forms current event:
If Nz(SEC_REF, "") = "" Then
Me.MIN_QTY.Visible = True
Else: Me.MIN_QTY.Visible = False
End If

but doesnt seem to work

Any Ideas??

 

[RuralGuy]

Try:

If Len(Me.SEC_REF &  "") = 0  Then
   Me.MIN_QTY.Visible = True
Else
   Me.MIN_QTY.Visible = False
End If

 

[lead 27]

Thanks for the reply.

yeah that works great

 

[RuralGuy]

You're welcome. Glad I could help.