Conditional Formating

[hi there]

hi all,

i have a form in my application that i would like to have access automatically "gray-out" certain controls when the user makes a selection from a combo box on my form. basically i'd like to link the BackColor property for 15 controls (text boxes) to the combo box selection, but still allow user entry in those controls. this is purely for aestetic purposes. the user might still have to enter information into those controls, but this isn't "normal" operation. here's a little background on my application:

i have a table named "tblDailyLog" with a lookup field named "shift" and the following other fields i'd like to perform the event procedure on: field1, field2, field3,....field15. i've created a form named "DailyLogEntryForm" using this table as the recordsource. on the form if the user selects "Day Shift" from the combo box, i want the event procedure to run and change the BackColor property for field1,...field15.

could someone help me with the code to do this. i have an idea of how to do this but i'm still very new to VBA and i'm not sure about the syntax. if someone could kinda walk me through it that'd be great. many thanks to all for any help.

 

[Travis]

Access 2000

In the Design View of the Form goto the Format menu, and select Conditional Formatting. The rest should be intuitive.

 

[hi there]

thanks travis. that worked perfectly.