Error handling of table update error?

[panoss]

I have a table which has a field with 'Requiered=Yes'.
A form is based on this table.
When I open the form (in form view) and edit a record, I leave this field empty. Null.
When I click on another field in the form, a message pops up showing the error:
Cannot update because the field is Required and cannot contain null value.
(everything as expected)

How can I do error handling?
The 'On Error' event of the form is not raised, the error does not happen in the "Before update' of the control...


I have put code to show me message if the error happens, in:
The control's before update.
In the form's before update.
In the Form_Dirty.
In the form Error event.
Nothing, the only error is raised from the application:

[ranman256]

In the table (and maybe the form) the field has a property:
VALIDATION RULE
or
ALLOW ZERO LENGHT = NO

change the design if needed,
or dont let the field be null

[panoss]

'Allow zero length' only applies to fields of 'text type'.
Mine is a number field.

Is there any way, in the table, when it's null to automatically become 0?
I tried with Nz function, but didn't achieve anything.

[panoss]

I set the field's required to false. So the error is gone.

I want on the 'before update' event of the field in the form, to check if it's null, and if it is then make it equal to 0.
But this can't set the field's value in the before update event of the field. It raises an error.
Should I use the field's 'lost focus' maybe? It doesn't sound too elegant...

[panoss]

I set the field's (and the respective control's in the form) default value to 0.
I used the AfterUpdate event of the field.

Private Sub GetesPieces_AfterUpdate()
    If IsNull(Me.GetesPieces) Then
        Me.GetesPieces = Me.GetesPieces.DefaultValue
    End If
End Sub

It works fine (before update of the field, if null, makes it 0) though I don't know if that's the 'neatest' way to do this.

[Missinglinq]

GetesPieces_AfterUpdate is not going to fire unless data is physically entered into the GetesPieces Control! If you set Zero as the Default Value, you need do nothing else! If no other value is entered, the Control, when the Record is saved, will be Zero!

Linq ;0)>