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.
=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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
= IIf(Field1 <> " ", "X", Field1)
ASKER