vb123.com.au
Adding a Decent Tick to Your Access Report
By Garry Robinson
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
Other Pages at VB123.com That You May
Want To Visit
Lookup Tables - Getting Rid
Of Junk data
Tuning Up Your Design
Toolbars In Access 2000/2002/2003
Click on the
button for the next
help page in this Access Loop.
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number
of popular computer magazines, is now a book author and has worked on
100+ Access databases. He is based in Sydney, Australia
Access 2003 Security
Adding a Decent Tick to Your Access Report
By Garry Robinson
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
Other Pages at VB123.com That You May Want To Visit
Lookup Tables - Getting Rid
Of Junk data
Tuning Up Your Design
Toolbars In Access 2000/2002/2003
Click on the
button for the next
help page in this Access Loop.
Our Tools and Resources
vb123 Professionals
Get Good Help Here
If you need help with a database or
Office programming,
our Professionals could be the answer because we have worked on many
similar solutions
Frontpage Conversions
We have converted vb123.com to Expression Web,
contact us if we can help you move to the latest Microsoft web tool.
About The Editor ~ Contact Us
Garry Robinson writes for a number
of popular computer magazines, is now a book author and has worked on
100+ Access databases. He is based in Sydney, Australia
Access 2003 Security
