I would like to change a field to a null value if a condition exists. If a
checkbox = no or is not checked i would like to create a macro that would
change the adjacent field to blank. I tried using setvalue in a macro and
creating spaces but the spaces are viewed as data. Please help
Rob
Barry Gilbert - 15 Sep 2006 17:58 GMT
Instead of using blank spaces, use Null for the expression property.
Barry
> I would like to change a field to a null value if a condition exists. If a
> checkbox = no or is not checked i would like to create a macro that would
> change the adjacent field to blank. I tried using setvalue in a macro and
> creating spaces but the spaces are viewed as data. Please help
>
> Rob