vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us

Order Software

Search vb123

 Smart Access  
The Magazine that Access Developers loved to read and write for is back
Article Index Here or
Purchase Here

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Sign up here

Get Good Help
If you need help with a database, our Australian Professionals could be the answer
Read More

  The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and zip backups, change startup options,  compile, shutdown database
Read and Download


Access > SqlServer 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

Like FMS Products?
Purchase them from us and get a free Workbench or Smart Access  More

The Toolbox
Libraries of software that we regularly import into our projects.  More..


Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor 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
Contact Us ...

 

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip   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

Mosaic of Wingdings characters 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 Next Tip button for the next help page in this Access Loop.

 


 

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals