Conditional formatting A2k

[Tim Graichen]

Hello,

I am using the built-in conditional formatting tool in Access 2000 to
disable a field (B) in my form based on the condition of another field (A)
in the same form.

This all works fine with one acception:

Currently, if the condition is met, and the field (B) becomes disabled, it
retains the field value it had before it was disabled.

I need to be able to is force the value of that field (B) to null and save
the record, as well as apply the conditional formatting (which in this case
is greying it out and disabling it).

In other words, whenever the field (B) is disabled due to conditional
formatting, it's value must be Null.

any help is appreciated

Tim G.