G
Guest
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
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