Applecore Pages on Microsoft Access

Resizing Check box controls

Unfortunately, the check box control in Access doesn't support resizing. The way to get around this in a report is to use a text box to simulate a check box. Create a new text box on the report, and set the controlsource for the field to the True/False field in your table. Set the control's Format property to:

;\X

which will display a cross when the field is true, or to display a cross when the field is false, use:

;;\X

You can then change the FontSize and FontWeight of the text box, to increase/decrease the emphasis of the simulated check box.

If you want to display a variable-sized tick mark, then you will need to change the Font. I use Monotype Sorts, and then set the control's format to:

;\3;\7

which will display a tick when the field is true, and a cross when the field is false. (There are two tick symbols in the Monotype Sorts Font, accessed by 3 or 4, and 4 different crosses, accessed by 5, 6, 7 or 8).

Top

 


HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES
E-MAIL
Copyright & Disclaimer

 

Last modified at 06/06/2006 15:00:53