BeforeUpdate problem - Runtime error 2115

Question

I have written the following query :

Private Sub Size_Sqft_BeforeUpdate(Cancel As Integer)
  Me!Size_Sqft = Nz(Me!Size_Sqft, 0)
End Sub

But while i removing the zero in the filed to make it null ,

i am getting the following error

Runtime error 2115

Macro and function set to before update and validation rule property for this field is preventing manual data entry screen for company from saving the data in the field.

Answer 1

You have to put that code in the AfterUpdate event of that field.