Access 2007 and back colors

[David]

Hi

In Access 2007 the back colors are showing in a shortened Hex form I
think (?), which is incompatible with the VBA command to set the
backcolor. For example I use a light blue color, which is showing as:
#7EC6DA but Me.Detail.BackC olor =#7EC6DA doesn't work!

What I would like to do is to conditionally format form back colors
according to a lookup critierias. Does anyone know the syntax for
setting the correct value for the new A2007 color properties in VBA?

thanks

David

[Allen Browne]

Re: Access 2007 and back colors

You should still be able to assign a 24-bit value, using a Long, a hex
value, or the RGB() function.

Examples:
Me.Detail.BackC olor = 14337662
Me.Detail.BackC olor = &HDAC67E
Me.Detail.BackC olor = RGB(&H7E, &HC6, &HDA)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" <deejayquai@gma il.comwrote in message
news:0633a96a-a365-483c-ba7e-4315c9434f96@d3 1g2000hsg.googl egroups.com...

Hi
>
In Access 2007 the back colors are showing in a shortened Hex form I
think (?), which is incompatible with the VBA command to set the
backcolor. For example I use a light blue color, which is showing as:
#7EC6DA but Me.Detail.BackC olor =#7EC6DA doesn't work!
>
What I would like to do is to conditionally format form back colors
according to a lookup critierias. Does anyone know the syntax for
setting the correct value for the new A2007 color properties in VBA?
>
thanks
>
David