Access 2003 - conditionally format form background color?

_Andy_

Hi

Is it possible to conditionally format the background color of a form according to what value a drop-down list field is? Or is there some kind of work around?

For the form I'm designing there is a drop-down field which the user can either choose 'East' or 'South East' from.
Ideally I'd like the background color to then change (e.g. if they select 'East' it goes blue, or 'South East' red, etc.)
The idea being that when we're viewing entries in form view it's easier to see straight away what region they're in.

Cheers for any help

Andy

loudcox

OK, you need to use some VBA.... If you don't know VBA, then PM me and I can guide you through implementing this.

STEP 1 - The update code

Private Sub SetFormColour()

Dim FormColour As Variant

Select Case [Region]
    Case "South"
        FormColour = vbRed
    Case "East"
        FormColour = vbGreen
    Case Else
        FormColour = -2147483633 'this is the default colour
End Select

Me.Detail.BackColor = FormColour
Me.FormHeader.BackColor = FormColour
Me.FormFooter.BackColor = FormColour

End Sub

STEP 2 - Calling this when things happen (such as changing the value or scrolling to a record). The example below calls the function whenever the dropdown is used to change the region.

Private Sub Region_Change()
    SetFormColour
End Sub

_Andy_

Awesome, thanks for that - will give it a go tomorrow. Trying to build up my VBA knowledge so it's all good.

loudcox

Cool. Probably the only other point at which you want to call the function is the OnCurrent event for the form.

Good luck
m