Results 1 to 6 of 6
  1. #1
    IamKJVonly is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2018
    Posts
    40

    Tabular from has alternate lines of background. Can I change this to all 1 background color?

    I know that right now a form set for tabular view has the background of each record alternating between light and dark.

    My question is this. Can I set the background of each record to the same color?

    Thanks for any help you can give me.

    Dave

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,928
    Try setting the Detail section AlternateBackColor property.

    Ooops, just tested and that does not work with Datasheet view. Probably have to use Continuous view and arrange controls to look like datasheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    IamKJVonly is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2018
    Posts
    40
    Thanks very much it solved the problem
    It was under the property of the background; under detail; and Alternate background set to "No Color"

    Thanks again June7 I just couldn't find out where to look.
    Now Happy days are here again.
    Dave

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    datasheets use different properties based on columns and rows rather than controls and sections and only available via vba - see this link

    https://docs.microsoft.com/en-us/off...sheetbackcolor

    you may have to set both back and alternate colors

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,928
    Interesting, tried that and doesn't work for Datasheet view.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    it works for me - in form open event

    Me.DatasheetBackColor = vbRed
    Me.DatasheetAlternateBackColor = vbGreen

    bit garish but it works

    but either way, looks like OP is not using a datasheet anyway

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

Similar Threads

  1. Change Text color and/or background color
    By Thompyt in forum Reports
    Replies: 2
    Last Post: 02-23-2017, 07:08 PM
  2. Replies: 4
    Last Post: 10-28-2014, 09:51 AM
  3. Replies: 2
    Last Post: 06-01-2014, 12:05 PM
  4. Replies: 3
    Last Post: 01-01-2014, 11:21 PM
  5. Change Row Background Color Programmatically
    By sales@4bco.com in forum Programming
    Replies: 2
    Last Post: 10-25-2009, 11:17 AM

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