Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How To?: Display Checkbox as yes / no on a report
- Thread starter LaCour
- Start date
groundclutter
Programmer
Put a textbox on the report...set the control source to your yes/no field....set the format to "Yes/No"...
GC
GC
- Thread starter
- #3
Groundclutter ... thanks ... your suggestion will yield the numeric value 0 for False anything else is True.
I declared a textbox and am using the following in the control source to evaluate the return value. I knew it would be something like this ... I was initially checking to see if the field was true or false, but Access "likes" to deal with 0 and -1 in this case.
For anyone doing something similar use this.
=IIf([YourBooleanYesNoField]=0,"No","Yes")
I declared a textbox and am using the following in the control source to evaluate the return value. I knew it would be something like this ... I was initially checking to see if the field was true or false, but Access "likes" to deal with 0 and -1 in this case.
For anyone doing something similar use this.
=IIf([YourBooleanYesNoField]=0,"No","Yes")
- Status
Similar threads
- Locked
- Question
- Locked
- Question