By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Access 2007 and back colors

P: n/a
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
Oct 3 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Oct 3 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.