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
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?
Microsoft ApplicationsMicrosoft OfficeMicrosoft Access
Last Comment
stuckp1
get rid of the quotes
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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.