Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Colors (Access 2007) (XP)

    In the property sheet, colors are now shown like #ED1C24 instead of a number. And, of course, you can't paste that value in code to a property like MyControl.ForeColor = #ED1C24 or MyControl.ForeColor = "#ED1C24" - - you now need to use the RGB (nn, nn, nn) format. Does anyone have a utility to convert between the two types of values?
    -dave

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Colors (Access 2007) (XP)

    This may do what you want - ColorCop

  3. #3
    New Lounger
    Join Date
    Sep 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Colors (Access 2007) (XP)

    Perfect!! Thanks for the help, and for such a quick response!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Colors (Access 2007) (XP)

    You can use hex values in code by preceding them with &H instead of #, for example

    MyControl.ForeColor = &HED1C24

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Colors (Access 2007) (XP)

    <P ID="edit" class=small>(Edited by mbarron on 29-Jun-07 09:27. Edited attachment)</P>Here's a rudimentary version I created in Access 2K.

Posting Permissions

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