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

Showing Checkboxes in a Report

by  itflash  Posted    (Edited  )

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]
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top