Change colour

[peterbowles]

Hi
Can you have a combo box on a form, which is populated with say 5 different colour, Red, Blue, White, Grey, Green

In the after update event can the background colour of the form be cahnged to which ever colour is selected in the combobox

Thanks

 

[Mile-O]

Yes, it's possible:

once the value is in the combobox use a SELECT CASE statement to change the BackColor property of your form's detail

Select Case cboYourCombo
   Case = "Red"
      Me.Detail.BackColor = RGB(255, 0, 0)
   Case = "White"
      Me.Detail.BackColor = RGB(255, 255, 255)
   Case = "Blue"
      Me.Detail.BackColor= RGB(0, 0, 255)
   etc. etc.
End Select

 

[Rich]

You could of course just use vbRed, vbBlack etc

 

[Mile-O]

What about vbReddishOrange, Rich? Is that a VB constant?