Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

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.
0
mekah
Asked:
mekah
1 Solution
 
Rey Obrero (Capricorn1)Commented:

IIF(Len(Trim([Field1]) & "")>0,"X","")
0
 
mekahAuthor Commented:
Thanks
0
 
hnasrCommented:
 = IIf(Field1 <> " ", "X", Field1)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now