Color Code from Hex to Long Int (1 Viewer)

[lina2401]

I am using Access 2007 and trying to set the BackColor property of a text
box on a form using VBA Code in the Form_Open event with code like this:


Me.txtName.BackColor = <some global variable>


Here's the thing: In order to get the correct color numer, I first pick my
desired color from the palette to see its value. In this case, a very bright
red comes up as #ED1C24.


In Access 2003 and earlier, this value would be represented as a long
integer, not a Hex. So, my question is how to get the HEX value converted to a long integer??

The BackColor property is supposed to be a long integer data type, but that is NOT what the design interface is presenting to me!

Why did Microsoft change the BackColor property of form and report objects from long integer representation to Hex?

CONFUSED!!

 

[boblarson]

Not the perfect solution but if you go here

http://www.easycalculation.com/hex-converter.php

you can convert the hex to decimal.

 

[Rabbie]

Why did Microsoft change the BackColor property of form and report objects from long integer representation to Hex?

CONFUSED!!

The hex format makes it easier to see the RED ,Green, and Blue Values directly. A long integer gives you little idea of how the colour is composed. As Bob said there ar plenty of converters out there in cyberspace.