470,609 Members | 1,472 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,609 developers. It's quick & easy.

Conditional formatting A2k


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.
Nov 12 '05 #1
0 1623

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bradley | last post: by
8 posts views Thread by Dimitri Furman | last post: by
2 posts views Thread by Von Bailey | last post: by
5 posts views Thread by Andrew Chanter | last post: by
1 post views Thread by GGerard | last post: by
2 posts views Thread by Filips Benoit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.