Check Box (1 Viewer)

YANKEE

Registered User.
Local time
Today, 06:15
Joined
Nov 9, 1999
Messages
10
I have several check boxes setup in my form tied to data fields. If I check the box the table stores a text value of -1. I would like use the check box information in a report that would display a value other than -1. For example, if the data value is -1 then print the word "YES" blank would be "NO". Can I test this data value in a if expression or should could this be accomplished another way? Thanks for any help in advance.
 

Lou

New member
Local time
Today, 06:15
Joined
Oct 6, 1999
Messages
8
I use the iif statement myself. Set it up as:
iif(value=-1,"YES","NO")

...Lou
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom