How to test if a control has data

Here is my code.
=IIf([Field1]="Yes","X"," ")

This code will mark my field with an X if Field1 has Yes in it. What do I replace Yes with if the field has any data in it? Even better but not a big deal is if field1 has any data other than a space.
mekahAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:

IIF(Len(Trim([Field1]) & "")>0,"X","")
0
 
mekahAuthor Commented:
Thanks
0
 
hnasrCommented:
 = IIf(Field1 <> " ", "X", Field1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.