In MS Access, is there a reason to prefer conditional formatting over setting formatting options with VBA? Is one more effecient or generally considered easier to read?
+3
A:
Conditional formatting works on continuous forms or subforms. VBA formatting doesn't work on continuous forms and subforms. Both work on standard forms.
Tony Toews
2009-08-15 01:43:48
But conditional formatting does have that slowness that is like what you get when you put a calculated expression as ControlSource of a form control. It's invaluable because of what it does, but a little quirky in terms of display.
David-W-Fenton
2009-08-15 02:50:59
A:
If you are familiar with Access or Excel but haven't used VBA, conditional formatting can be preferable because you don't have to learn nearly so much. I realize this answer is probably not applicable from the asker's point of view, but it may be important to someone with less knowledge generally.
Smandoli
2009-08-17 14:36:46