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?
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.
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.
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.
example:
controlname.ForeColor = 88888
controlname.BackColor = 0