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.BackColor =#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]

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

Examples:
Me.Detail.BackColor = 14337662
Me.Detail.BackColor = &HDAC67E
Me.Detail.BackColor = 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" <de********@gmail.comwrote in message
news:06**********************************@d31g2000 hsg.googlegroups.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.BackColor =#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