By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,482 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,482 IT Pros & Developers. It's quick & easy.

Set "backcolor" property in form with macro that holds

P: 6
I am trying to set the "backcolor" property in fields in a form. It sets okay using a macro (setvalue). But when I close the form, the property settings revert back to what they were before I closed the form. So when I reopen the form, the settings are not changed. If I manually change the settings while not in Design mode (using the "fill with" icon), the settings hold. If I change the settings while in Design mode, the settings do not hold.
My goal is to have a form that indicates the status of individual "units" determined by the backcolor of each field that refers to a unit. I want to have a macro that will automatically set the backcolor of the field when the status of the unit changes.

Thanks in advance for your expert opinion.

Bill Stillwell
Nov 22 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
Is this a continuous form or sinle view? You might want to take a look at Conditional Formatting if you're running Access 2000 or later.
Nov 22 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.