microsoft.public.word.vba.general

"kW in mD" wrote:

> Hi,
> I have developed a document for a client in which 13 rows of fields with 3
> columns each auto-calculate into 3 separate totals. The client is now
> requesting that, if they enter zero into the first column of any row, the
> other 2 columns are immediately updated to be zero as well. However, this
> should only happen with the number zero. How can I program the fields to do
> this and still auto-calculate?

Just about to leave for the weekend... just had an idea.. don't know if it
will work...

The probklem you have is that a field is either user-fillable or it is
automatic(Formfield vs Formula). You can't really have both.

One idea I have is that you have a macro On Exit for the fields in the first
column of each row. First make sure that all fields have a default value of 0.
The macro would check if the field is equal to 0, if it is, set all other
fields on the same row to their default value (0) and disable them. If it is
not 0, enable the fields on the same row.