Rich P <rpng... at (no spam) aol.com> wrote in news:4ae1df25$0$1328
$815e3... at (no spam) news.qwest.net:







I searched around for articles on converting hex to RGB
numbers, but
found sites that only perform the operation but don't show
the source
code for doing this.  So I guess it isn't trivial.  One
thing you could
do is get a table of Hex to RGB values and create your own
table within
Access and then --

--
here is the site which has such a table including the
associated colors

http://web.njit.edu/~kevin/rgb.txt.html
--

peform the matches yourself.  Like 7F00FF is purple(ish) and
the
corresponding RGB values are 127;0;255.  Then use the RGB
function (in
VBA) to apply the selected color.

Rich

*** Sent via Developersdexhttp://www.developersdex.com***

Rich, Thanks for the reply.
I did not think that Access could use RGB codes ? The color
codes you see on the property forms are just Long numbers -
can't make any sense of what they represent but when setting
color properties, this is what Access wants !

I need to be able to do this on the fly for any entered HTML
color so I don't think I can go th way of a lookup table.

Thanks- Hide quoted text -

- Show quoted text -

I searched around for articles on converting hex to RGB
numbers, but
found sites that only perform the operation but don't show
the source
code for doing this. So I guess it isn't trivial. One
thing you could
do is get a table of Hex to RGB values and create your own
table within
Access and then --

--
here is the site which has such a table including the
associated colors

http://web.njit.edu/~kevin/rgb.txt.html
--

peform the matches yourself. Like 7F00FF is purple(ish) and
the
corresponding RGB values are 127;0;255. Then use the RGB
function (in
VBA) to apply the selected color.


Rich

*** Sent via Developersdex http://www.developersdex.com ***

I have HTML color codes stored in fields - how do I convert
these to accurate Access color codes that can be used to set
background colors to Access Rectangle controls, text color etc.
I know how to change the control properties but I cannot convert
HTML color codes to Access color codes.

Thanks