Message on a FORM

[rpadminserver]

Hello all...

How can I get a label to appear on a form, if a field is populate.

I have an issues table. In that issues table there is a NOTES field. This notes field does not display on the form where issue detail is displayed (not enough space), what i want to do is have a label(?) appear that tells the user there are notes for this issue.

Thanks all

Rob

 

[rpadminserver]

Figures... After posting this i figured it out....

On the form,
Under the On Current event

If IsNull(Me.NOTES) Then
Me.Label97.Visible = False
Else
Me.Label97.Visible = True
End If