Form Background color

[Daniel]

Hello,

I was previously using conditional formatting to control the background
color of my form. however, I now have too many criteria to check for and
have to migrate this functionality ti VBA on the current event of my form.

I tried using the Form.DatasheetBackcolor but it doesn't appear to work. I
am using access 2000. My form is in single form mode. How can I change the
background color of the entire form based on the value in a specific field
'Status'?

thank you,

Daniel

 

[Allen Browne]

Set the BackColor property of the Detail section of the form, i.e.:
Me.Sections(acDetail).BackColor = RGB(99, 99, 99)

 

[Daniel]

I did some testing and now realize that as it would indicate the
DatasheetBackcolor works when the form is displayed as a Datasheet (there's a
concept).

So How does one achieve the same result when in single form mode?

Daniel

 

[Daniel]

Thank you, thank work beautifully!

Set the BackColor property of the Detail section of the form, i.e.:
Me.Sections(acDetail).BackColor = RGB(99, 99, 99)