Change the background colour of form depending on option selected?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

I've created a telephone log which has a field called Priority. This combo
box has 5 options,

Hightly Urgent, For Info Only, Please Call Back, Personal, Copy, Low Priority.

Is it possible to change the background colour of the form that displays
this information depending on the option selected. I.e. Highly Urgent - back
ground colour is a red, Low Priority a calmer Yellow?
 
I assume you are on Normal Form View, i.e. single Record View.

Try using the PriorityControl_AfterUpdate Event and the Form_Current (if you
want to do the same for viewing existing Records) to set the BackColor of
the Form sections. You can reference each section of the Form (Header /
Footer / Detail ...) using the Section Property of the Form.

Check Access VB Help on BackColor and Section Property.
 
in Access2002 and beyond; while in the Form - design view - select the Text
Box and right click - - you will see "Conditional Format" as a choice.....

may be in earlier versions - I don't know as we are not backward
compatible....!!
 
Back
Top