Access 2010 VBA: Looked all over but can't find straight answer for how to set color property of field using, #NNNNNN format
13 martie 2012 21:15
I have this VBA statement
Form_Storage_Automation_Main_Form.HBA1.BackColor = "#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?
13 martie 2012 21:21
Form_Storage_Automation_Main_Form.HBA1.BackColor = &HF8F8F8
Andrey V Artemyev | Saint-Petersburg, Russia
Russian blog artemyev.biztoolbox.ru
- Marcat ca răspuns de stuckip 13 martie 2012 21:23
13 martie 2012 21:24
13 martie 2012 21:51Nice technique. You might also want to look at the more traditional technique of using the "RGB()" function; although I actually like Andrey's technique better.
Matthew Slyman M.A. (Camb.)
14 martie 2012 18:41