Avatar

Level 1

Hi Bruce,

Thanks for the reply. The problem is that there is a side effect of the Calculate event in other fields processing a null/zero value before it is changed by the Validate event on the offending field and that comes in the form of an "Error: arithmetic over/underflow" error dialog which the user then has to close before proceeding. Apparently I should be able to use the Calculate event on the offending field to trap the issue before other Calculate events fire, but I have tried numerous scripts and settings but all to no avail

Thanks,

Rod.