Problem with alternate back color property

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mustangarcher
    New Member
    • Feb 2014
    • 8

    Problem with alternate back color property

    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
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32662

    #2
    Check the .BackStyle property. I would guess it's set to Transparent for some of them, but Normal for the others.

    Comment

    • mustangarcher
      New Member
      • Feb 2014
      • 8

      #3
      Originally posted by NeoPa
      Check the .BackStyle property. I would guess it's set to Transparent for some of them, but Normal for the others.
      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.

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        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.

        Comment

        • mustangarcher
          New Member
          • Feb 2014
          • 8

          #5
          Originally posted 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.
          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!

          Comment

          Working...