If Statement for Memo Field

D

Dave Elliott

I have a memo field on my form named Job with it's control source set to Job
Description
On the main forms current event is the below code. I want the Label368 to be
visible if the memo field says None in it, else not visible.
Do I need to set the default value of the memo field to =None ?
The label368 is set to Not Visible by default.
What am I doing wrong? The Label368 is showing all the time.
Also I dont want the Label368 to be visible if anything else is in the memo
field besides the name None



If ([Job Description]) = "None" Then
Label368.Visible = True
Else:
Label368.Visible = False
End If
 
Top