Form header and detail backColor error in VBA

[evanark]

A user requested a change that would change the form header and detail back ground color to white when they click the button print record and then change the color back all in one click after the record prints. I keeping getting a run time error, type mismatch on the line where to code is to be changed. Is my code wrong? The colors are numbers not vbColors. I am using Access 2007.

Me.FormHeader.BackColor = "#FFFFFF"
Me.Detail.BackColor = "#FFFFFF"

 

[James Dudden]

You need to send the colour in a format Access can understand. Take a look at this:

http://www.endprod.com/colors/

 

[MSAccessRookie]

Hexidecimal is not the proper type for the parameter neeeded to define BackColor. It needs to be a Long Integer. The Link below describes how to convert the Hex to Long

http://support.microsoft.com/kb/161304

-- Rookie

 

[evanark]

Thanks for the assistance!!