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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Showing Checkboxes in a Report
Reports
Instead of showing .T. or .F. in your report, I show ticked/unticked check boxes. It looks much neater.
To display the checkboxes, I use the wingdings2 font, so you must ensure that you have this font and your printer can cope with it.
So.........
1. In your report, create a field.
2. Make your field use the wingdings2 font.
- highlight the field,
- menu option "format", option "font".
2. In the field put the following statement,
adjusting it for your own cursor/table etc.
iif(mycursor.field1), 'R', 'Q')
What this will do is display R if your field is .T. and Q if your field is .F. HOWEVER, by using the wingdings2 font, a ticked or unticked check box will appear instead of Q and R!
Looks nice and very easy.
ITflash
![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")