Aussiebob -

Chances are you don't have code behind all the events you need and/or the
code is not complete.

For example, you may have code in the OnCurrent event of a form, which test
and format the form as you scroll through new records, but it would not help
if the user changed a value on a current record. If there are a lot of
events that should trigger this code, then the code should be in a form
procedure that you can call from each event that could affect the formatting.

Also, you may have code that is 'half' there, such as an if statement with a
conditional formatting but no else clause to set the formatting back to
normal.

If you want more help, post your code, and include when/how it is called.

--
Daryl S


"aussiebob" wrote:

I have a form which includes several fields with conditional formats. the
format is determined by the user ticking a yes/no box included in both the
Table and the Query from which the form is created.
when i open the Form the previously saved format is displayed but the user
cannot turn off the format with the yes/no box. However if i open the
underlying query in design view and the close it the form works ok.
Any help appreciated.