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 / December 2005

Tip: Looking for answers? Try searching our database.

Please help with Conditional Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TotallyConfused - 05 Dec 2005 21:31 GMT
I can't seem to set conditional formatting with a check box on a form.  I
want to be able to highlight row in form if checkbox is checked.  Can this be
done without using code?  Newbie to VB.  Any help will be greatly appreciated.
Marshall Barton - 05 Dec 2005 22:18 GMT
>I can't seem to set conditional formatting with a check box on a form.  I
>want to be able to highlight row in form if checkbox is checked.  Can this be
>done without using code?

You don't want to conditionally format the check box (which
is pretty useless anyway), you want to format something else
depending on the value in the check box.

You can not conditionally format the form's (Report?) detail
section, but you can add a large text box that's sized and
positioned to filee the detail section.  Set its Conditional
Formatting - Expression Is option to [thecheckbox] = True
and then use Format - Send to Back to move the text box
bhind all the other controls.  Youwill probably also want to
set some of the other controls BackStyle property to
Transparent.

Signature

Marsh
MVP [MS Access]

TotallyConfused - 06 Dec 2005 16:51 GMT
Thank you very much for your help.  It works great!

> >I can't seem to set conditional formatting with a check box on a form.  I
> >want to be able to highlight row in form if checkbox is checked.  Can this be
[quoted text clipped - 12 lines]
> set some of the other controls BackStyle property to
> Transparent.
 
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.