Reputation: 14883
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?
Upvotes: 1
Views: 1127
Reputation: 7019
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.
Upvotes: 0
Reputation: 7882
Conditional formatting works on continuous forms or subforms. VBA formatting doesn't work on continuous forms and subforms. Both work on standard forms.
Upvotes: 5