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

Problem with alternate back color property

P: 8
Hello. I do not have any code associated with this problem. This is a property setting in the detail section of some datasheet forms. I have 9 datasheet forms in my database. All of them have the alternate back color property set to "no color".. On 2 of them, it works just fine. On the other 7, the alternate rows are colored with the default color no matter what the setting is. I don't know what I am doing wrong.

Thanks,
Mike
Mar 4 '14 #1

✓ answered by zmbd

Which version of access?

Also, in design view, show properties for any control in the form.
On the dropdown at the top of the properties dialog, select "Detail"
Check the format tab and see what the colours are set to for "Back Color" and "Alternate Back Color"

Useing the dropdown list, select each control that you have in the details section and check the same properties.

Use your working forms as a reference so that you can duplicate these settings.

Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,769
Check the .BackStyle property. I would guess it's set to Transparent for some of them, but Normal for the others.
Mar 5 '14 #2

P: 8
@NeoPa
Thanks, but no luck. The only .BackStyle property I could find was for the controls. They are the same on all of the forms (Normal for Textboxes and Transparent for Lables). The Detail and Form properties do not have a .BackStyle property. But the Detail properties has a .BackColor property and is set to "Background 1" for all of the forms.
Mar 5 '14 #3

zmbd
Expert Mod 5K+
P: 5,397
Which version of access?

Also, in design view, show properties for any control in the form.
On the dropdown at the top of the properties dialog, select "Detail"
Check the format tab and see what the colours are set to for "Back Color" and "Alternate Back Color"

Useing the dropdown list, select each control that you have in the details section and check the same properties.

Use your working forms as a reference so that you can duplicate these settings.
Mar 5 '14 #4

P: 8
@zmbd
It is Access 2010.

I just figured it out. The two that were working were created before the other 7. It turns out that all of them are ignoring the "Alternate Back Color" setting in the "Detail" properties section in "Design View". The difference was that there is an "Alternate Row Color" setting on the ribbon in "Datasheet View". I must have forgotten that from the time I created the first 2 forms.

Thanks!
Mar 5 '14 #5

Post your reply

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