stuckp1
asked on
Access 2010 VBA: Looked all over but can't find straight answer for how to set color property of field using, #NNNNNN format
Background:
I have this VBA statement
Form_Storage_Automation_Ma in_Form.HB A1.BackCol or = "#F8F8F8"
I'm getting a "Type Mismatch" error.
I've looked through many online blogs and forums without success. The approach above I got out of a VB example. Is there a difference in VBA?
I don't understand what even the type would be?
What would be the correct way to do this?
I have this VBA statement
Form_Storage_Automation_Ma
I'm getting a "Type Mismatch" error.
I've looked through many online blogs and forums without success. The approach above I got out of a VB example. Is there a difference in VBA?
I don't understand what even the type would be?
What would be the correct way to do this?
get rid of the quotes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The removal of quotes didn't work for me, but Daniel's example did work.
What also works is to use MSAccess
Form_Storage_Automation_Ma in_Form.Sn apshot_Qua ntity.Back Color = 11908533
See http://www.endprod.com/colors/
Again, thanks to everyone.
What also works is to use MSAccess
Form_Storage_Automation_Ma
See http://www.endprod.com/colors/
Again, thanks to everyone.