View Full Version : Check Box


YANKEE
11-09-1999, 11:29 AM
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
11-10-1999, 05:56 AM
I use the iif statement myself. Set it up as:
iif(value=-1,"YES","NO")

...Lou