Conditional formatting issue

[NevilleT]

I am using conditional formatting applied through VBA to a subform in the
OnOpen event. Problem is that when the form opens, the formatting does not
work until I pass the mouse over the records. Tried Repaint but that didn't
work. Any ideas?

 

[Arvin Meyer MVP]

I think, conditional formatting only works on existing records. If you are
looking at defaults, they haven't been committed yet. It should work with
having to move the mouse. Try setting focus to the subform in the form's
current event. If that doesn't solve the problem, you may have a corrupt
form.

 

[NevilleT]

Tried that but no success. If the first record has conditional formatting to
be applied it happens but not subsequent records.

 

[Arvin Meyer MVP]

Is your data bound to the subform?

 

[NevilleT]

Yes. There is a query bound to the subform. The main form is basically a
holder for the datasheet subform.

 

[Arvin Meyer MVP]

Which version of Access are you using. This bug only happens rarely in
certain versions usually when trying to format a calculated control.

Try applying Service Pack 1 if you are using Access 2003. If it's another
version, you'll need to forget using it on a calculated control.