Results 1 to 5 of 5
  1. #1
    HankB is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    Milwaukee
    Posts
    15

    Using VBA how is color set in Access 2010 for foreground and background of controls?


    Using VBA how is color set in Access 2010 for foreground and background of controls?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why do you need to do this? Is this on form or report? Explore use of Conditional Formatting.
    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
    HankB is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2013
    Location
    Milwaukee
    Posts
    15
    I want to show the action of toggle buttons, clearly. To do this is wish to change the background color. I've accomplished this to some extent by setting BackColor and PressedBackColor in design mode. But I'd like to be able to do it in Form Mode.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Is the form in Continuous or Datasheet view? Will have to use Conditional Formatting.
    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.

  5. #5
    akhmadahdiyat is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    21
    example:
    controlname.ForeColor = 88888
    controlname.BackColor = 0

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

Similar Threads

  1. background image on Access 2010 form
    By lkspitz in forum Forms
    Replies: 2
    Last Post: 06-16-2011, 08:35 AM
  2. Background Color
    By Meccer in forum Access
    Replies: 4
    Last Post: 05-30-2011, 06:49 AM
  3. Background color for fields in a subform
    By eric.opperman1@gmail.com in forum Forms
    Replies: 3
    Last Post: 03-19-2011, 07:46 PM
  4. Change Row Background Color Programmatically
    By sales@4bco.com in forum Programming
    Replies: 2
    Last Post: 10-25-2009, 11:17 AM
  5. background color in a form
    By taggart in forum Forms
    Replies: 1
    Last Post: 05-07-2009, 10:37 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