View Single Post
 
Old 06-24-2015, 01:48 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You are mistaken if you believe a field with an amount or text can be updated after writing in it via either the 'Calculate on Exit' property or via a general VBA .Fields.Update method. If someone can write in a Field, it cannot be dependent on any other field. In any event, as I already said:
Quote:
other events, such as printing or previewing the document can also trigger updates
This applies to auto-updating fields, such as DATE fields and to fields of any kind that reference other fields or document properties.

If your concern is to prevent a field that has already had some kind of user input from being edited, all you need do is change its type property to a 'Calculation' field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote