over-ride a calculated field

[jenncivello]

Is there a way to over-ride a calculated field? I only need to do this a handful of times, is this possible?

[ItsMe]

I do not think so. Are you referring to a calculated field that is a calculated field because of its properties at the table level?

[Missinglinq]

As ItsMe said, not if it's truly a calculated Field. Depending on what, exactly, you mean by 'calculated,' you could possibly either

• Use the calculation in the Control's Default Value, which can then be overwritten, if need be
• Or in the Form_BeforeUpdate event, check to see if the Control is Null (empty) and if it is, use the calculation to then populate it.

Linq ;0)>