TimothyAWiseman
TimothyAWiseman

Reputation: 14883

conditional formatting or formatting with VBA

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

Answers (2)

Smandoli
Smandoli

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

Tony Toews
Tony Toews

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

Related Questions