Conditional formatting Access 2007 colors syntax

[sportsguy]

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]

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/arch...-color-codes-so-you-can-use-them-in-code.aspx