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 / Forms Programming / March 2007

Tip: Looking for answers? Try searching our database.

form field background color conditional on another field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sharkbytes - 18 Mar 2007 21:54 GMT
I want the background color of field last_name to change to gray if the value
of the field deceased? is true
fredg - 18 Mar 2007 22:07 GMT
> I want the background color of field last_name to change to gray if the value
> of the field deceased? is true

In Form Design View, select the [last_Name] control.
Then click on Format + Conditional Formatting

Set Condition1 to:
Expression Is
Then write:
[Deceased] = True
in the next box.
Set the color to gray.
Save the changes.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
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.