Results 1 to 6 of 6
  1. #1
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071

    Alternate Back Color Property

    Can anyone tell me what this property is for?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Like it sounds, it alternates the back color of the section. From hellp:

    Gets or sets the background color to display on alternate rows of the specified section.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071
    That's what I thought it was supposed to be but when I look at the report It sets the background color about once every 18 rows. I have it in the detail section which displays a member name, member id, and phone number to contact the member. I must be doing something wrong but I'll be damned if I know what it is. What I want is for the detail line only to be alternating colors. So I set all of the Groups to no color and only the detail section alternate back color property to Background 1, Darker 5% am I missing something?????

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Not sure without seeing it. Just tested and it worked as expected:

    Click image for larger version. 

Name:	Alternating.jpg 
Views:	9 
Size:	161.2 KB 
ID:	10028
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071
    That's what I'm trying to get unfortunately I work in Health care and HIPAA Regulations prevent me from displaying the report here. However using your report as a sample the first 11/12/2012 Line would be the only one with gray background the rest are white.

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Not sure offhand, but I'll ponder it. I tried on two different reports and both worked fine.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Turn off alternate row color
    By dombrowb in forum Access
    Replies: 3
    Last Post: 05-06-2015, 08:37 AM
  2. Form Back Color, screen only?
    By LostInAccess in forum Forms
    Replies: 2
    Last Post: 07-19-2012, 08:39 PM
  3. Alternate Row Color
    By mdaneman in forum Access
    Replies: 1
    Last Post: 06-21-2012, 12:39 AM
  4. Alternate Back Color not working properly
    By kolarbr in forum Access
    Replies: 7
    Last Post: 08-30-2011, 10:16 AM
  5. Alternate Row color get rid of
    By gg80 in forum Forms
    Replies: 3
    Last Post: 02-18-2011, 07:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums