Conditional formatting issue

  • Thread starter Thread starter NevilleT
  • Start date Start date
N

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?
 
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.
 
Tried that but no success. If the first record has conditional formatting to
be applied it happens but not subsequent records.
 
Yes. There is a query bound to the subform. The main form is basically a
holder for the datasheet subform.
 
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.
 
Back
Top