Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    How can I change the backcolor of the detail section by group in my report of Access 2003? Now I have different backcolor per row.

    Thanks in advance.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I am not clear what you mean.
    Do you want to change in code so that the backcolour of each row is different?
    or have you somehow got them all different and you want to make them the same?

    If you want to change the colour via code, do it in the On format event for the detail section.

    Code:
    Me.Section(acDetail).BackColor = RGB(125, 125, 125)
    Colour is a number, but I find using the RGB function makes more sense to me. the three numbers represent the amount of Red, Green and Blue on a scale of 0 to 255.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •