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

Change background color of entire row(s)

100+
P: 129
Just wondering if this is possible. If i had a form displaying continuous data, can i change the background colour of certain rows if i state the syntax to which i require it to?
Oct 22 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
The only way to do it is to use conditional formatting on, say, a rectangle object placed behind your controls on your form. In the query on which you base your subform include a calculated field whose value is, say, True if your condition that you need to test is satisfied and false otherwise, then use conditional formatting to change the background colour of the rectangle when the calculated field has the value True.

Reason you can't do it for the normal background of the form is that continuous forms comprise just one background and set of controls, repeated many times to display the rows (as explained in passing in NeoPa's article Why Values in Unbound Form Controls Don't Persist).

-Stewart
Oct 22 '08 #2

Post your reply

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