Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Conditonal formatting a checkbox in a report...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James Newman - 30 Oct 2004 01:11 GMT
Hey all,

I am hoping this is a very simple question to answer.  I am using
Access 2003 and have a report that has two text box fields and 12
checkbox fields the display a Paid/Unpaid status for each month.  All
of these fields are located in the detail section of the report.

I would like to conditionally format the checkboxes and their labels
to appear red when unpaid (no check).  If I select either of the two
text box fields I can select conditional formatting from the menu bar
but if I select any of the 12 checkboxes the conditional formatting
option is grayed out.

Am I missing something simple here??

Thanks for any help,
James Newman
Allen Browne - 30 Oct 2004 02:44 GMT
I don't think you can apply conditional formatting to a check box, so how
about a text box that simulates the check box?

Delete the check box from the report.

Replace it with a text box, and set these properties:
   Control Source    NameOfYourYesNoField
   Name                 NameOfYourYesNoField
   Font Name          Wingdings
   Width                0.18 in
   Format                            {see below}

Type these 3 characters in the Format property:
- Hold down Alt, and type 0168 on the numeric keypad. Release Alt.
- Type Backslash
- Hold down Alt, and type 0254 on the numeric keypad. Release Alt.

Now apply conditional formatting. The text box has the value True or False.

Duplicate this text box for your other fields as well.

The trick relies on the fact that Access uses 0 for False, and -1 for True.
The Format expression tells it to use different formatting for a negative
number. The actual formatting expressions are the Wingdings characters that
look like unchecked and checked boxes. If you have the Character Map
installed (Windows applet), use it to find the characters.

It's a useful trick, giving you not only conditional formatting and coloured
check boxes, but resizeable check boxes (just change the font size), blanks
for False, and unboxed check marks for True.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I am hoping this is a very simple question to answer.  I am using
> Access 2003 and have a report that has two text box fields and 12
[quoted text clipped - 11 lines]
> Thanks for any help,
> James Newman
Allen Browne - 30 Oct 2004 11:33 GMT
More detail in new web page:
   Check boxes on reports
at:
   http://members.iinet.net.au/~allenbrowne/ser-52.html

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I don't think you can apply conditional formatting to a check box, so how
>about a text box that simulates the check box?
[quoted text clipped - 43 lines]
>> Thanks for any help,
>> James Newman
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.