PDA

View Full Version : Conditional formatting Access 2007 colors syntax

sportsguy
09-09-2010, 10:33 AM
What is the proper syntax to set the backcolor to #FAF3E8??


Private Sub GroupFooter7_Format(Cancel As Integer, FormatCount As Integer)

If Me.ftrQuota = "Bookings" Then
Me.Box30.BackColor = vbWhite
Else
Me.Box30.BackColor = vbYellow
Me.Box30.BackColor = "#FAF3E8"

End If

End Sub


thanks
sportsguy
Trevor G
09-10-2010, 12:44 AM
What is the proper syntax to set the backcolor to #FAF3E8??


Private Sub GroupFooter7_Format(Cancel As Integer, FormatCount As Integer)

If Me.ftrQuota = "Bookings" Then
Me.Box30.BackColor = vbWhite
Else
Me.Box30.BackColor = vbYellow
Me.Box30.BackColor = "#FAF3E8"

End If

End Sub


thanks
sportsguy

Take a look at this link as it explains you will need to convert the Hexadecimal Code

http://blogs.msdn.com/b/access/archive/2009/10/26/convert-hexadecimal-color-codes-so-you-can-use-them-in-code.aspx