Converting a check box to Yes or No in report (1 Viewer)

Johnny Drama

In need of beer...
Local time
Today, 14:19
Joined
Dec 12, 2008
Messages
211
This is probably so simple that I'm overlooking it, but I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out.

Thoughts?

Thanks in advance!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:19
Joined
Aug 30, 2003
Messages
36,118
Try a textbox control source of:

=IIf(FieldName = -1, "Yes", "No")
 

Johnny Drama

In need of beer...
Local time
Today, 14:19
Joined
Dec 12, 2008
Messages
211
You, sir, are the man. Thanks for the quick response!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:19
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom