I am working on a MS Word form.
I have several lines in a table that are calculations (column1 * column2 = column3).

The value fields (column1 and column2) will remain blank unless there are values entered into them.

But the calculation field (column3) will always show "0.00" if there are no values in the two value fields (column1 and column2).

What I want is for the calculation field (column3) to show blank if there is no value in it.

There is no option for a default 'blank' value in a calculation field.

I am thinking about writing a macro that would delete or otherwise 'blank' out this field if there is no value to be displayed in it.

Unfortunately, although I program in 8 different high level languages I am a novice in VBA (which I believe is the word macro language).

How can I go about 'blanking these fields?

Any help would be greatly appreciated.

Thanks.
Back to top