How to Change Background Image / Colour Conditionally

[Tomhoneyman]

Hi,



I want to change the background colour of the detail section within a form but want to change it so that it changes colour conditionally based on what a cell is equal to.

For example:
The background changes colour to 'Yellow' if job status = 'Quote'
The background changes colour to 'Transparent' if job status = 'Won'

Is there a way of doing this?

Tom

[ranman256]

If the job status is in a table (for user selection)
add field 'color' as long, and set the color value for each 'status'
then in the Afterupdate event of the combo box,

me.backcolor = cboBox.column(2)
(or the column you set color to) be sure to set combo.columns = 2 (or more to include the color)

[Tomhoneyman]

Yes the job status is chosen from a dropdown list and stored in a table.

What do you mean by add field 'color' as long, and set the color value for each 'status' How do I do this?

[ranman256]

TABLE:
status, color
active, 221544
inactive,99441

then integers are color values.
the combo will have 2 columns, in properties
then when user picks it...

sub cboBox_afterupdate()
  'NOTE in code column#s start with zero, so col-0 is really the 1st column, col1 is the second one.
  
  me.backcolor = cboBox.column(1)      'but really column2
end sub