Change box colour of combo

  • Thread starter Thread starter callieandmark
  • Start date Start date
C

callieandmark

I have a form which is a log of jobs in my database
I have : OrderID,Customer,Order Date, Status.
The status box is a dropdown combo.
Is there a way that I can change the colour of all the boxes in that
line depanding on what the staus is set to.

Example, if I change the status from "In Production" to "Completed" I
would like that lines entries to all be in say red.
Thanks
 
I have a form which is a log of jobs in my database
I have : OrderID,Customer,Order Date, Status.
The status box is a dropdown combo.
Is there a way that I can change the colour of all the boxes in that
line depanding on what the staus is set to.

Example, if I change the status from "In Production" to "Completed" I
would like that lines entries to all be in say red.
Thanks
Click to expand...

That line's entries? Does that mean a form in datasheet view or a
continuous form rather than in 'normal form view'? If so then you need to
use conditional formatting which is rather limited and requires A2K or
greater, but is at least easy to set up. If in form view, you can do more
exciting things using the events of the form and combobox as you move
through the records/change the status.
 
The form is in Continuous Form view. Any pointers on how to set this up
?
Click to expand...

In design view, highlight a textbox then choose from the main menu
Format>Conditional Formatting. Then you select, say Expression Is and enter
[Status]="Completed" and then select the pretty colours for the font,
background, etc.
 
Back
Top