Adding a Tick To Your Access Report

If you want a tick (or an empty box) in a report that doesn’t look as quirky as a check box, its time to add a new field to your query and use the Chr() function. Then add that new field to the report and assign the data control the WindDings font. Thanks to Armen Stein of J Street Technology, Access MVP and Author for the inspiration for this tip.  Look at the picture and you will see how it is done.

External Links

See the fonts http://www.alanwood.net/demos/wingdings.html

Read about the history http://en.wikipedia.org/wiki/Wingdings

Comments By Others

Regarding the ticks on the report, I use the same technique quite often, and particularly on reports and Command Buttons, to give me access to a lite version of many pictures without having to (a) supply image files or (b) embed them (and thus bloat the database filesize). Unfortunately, in ListBoxes and the like, it only works for the single-byte character sets.

Regards,

Graham R Seach,  Access MVP

 

 

 

 

 

 

 

About Garry Robinson

He is the guy who originally put this Smart Access web site together. Head to www.gr-fx.com.au for more about him and his company. His main claim to fame is winning the Microsoft MVP award for services to MS Access from 2006 to 2018.
This entry was posted in Reports and Graphs. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.