Repost: Conditional formatting not shown when opening datasheet subform

In Access 2000 (ServiceRelease 1) I have a subform in Datasheet view. On one
field I have applied conditional formatting: the back color is set to red,
based on some condition.

The problem is that the red back color is not shown when I open the form.
Only when I move the mouse over the column, the red color is shown (if
applicable).

Why is this happening and how can I solve it?

Thanks in advance,

HJ

re: Repost: Conditional formatting not shown when opening datasheet subform

> In Access 2000 (ServiceRelease 1) I have a subform in Datasheet view.[color=blue]
> On one field I have applied conditional formatting: the back color is
> set to red, based on some condition.
>
> The problem is that the red back color is not shown when I open the
> form. Only when I move the mouse over the column, the red color is
> shown (if applicable).
>
> Why is this happening and how can I solve it?[/color]

Try one of the following, in the specified order:

1) Me.Redraw
2) Me.Refresh
3) Me.Requery

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution