Access and VBA - default value of field is null?

Question

I'm making a form with Microsoft Access and I'm trying to make an AfterUpdate event procedure for a field. I need to know if the value of that field is the default value (or if it's empy). I read that the default value of a field in VBA is Null so I made this:

Private Sub EB1_10_Val1_AfterUpdate()
    If Me.EB1_10_Val1.Value = Null Then
        MsgBox "hello"
    End If
End Sub

This didn't work so I tried this for when the user updates the value in the field and then erases it (empties the field)

Private Sub EB1_10_Val1_AfterUpdate()
    If Me.EB1_10_Val1.Value = Empty Then
        MsgBox "hello"
    End If
End Sub

The messages never pop up. On the other hand I tried changing the default value of the field to 0 but Its not working. The 0 doesn't appear in the field as default when in Form View.

Try checking with isnull(Me.EB1_10_Val1.Value) and isEmpty(Me.EB1_10_Val1.Value) — Roland
– Roland, Commented Jul 27, 2015 at 8:56

mielk · Accepted Answer · 2015-07-27 08:56:09Z

3

You can check if the field is empty with this expression:

If IsNull(Me.EB1_10_Val1.Value) Then

answered Jul 27, 2015 at 8:56

mielk

3,94014 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:14:01Z

0

In addition to solution provided by mielk, you can use Nz or Iif function to replace Null with default value.

Usage:

myVal = Nz(Me.SomTextBox, 0)

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Jul 27, 2015 at 9:42

Maciej Los

8,6211 gold badge22 silver badges36 bronze badges

Collectives™ on Stack Overflow

Access and VBA - default value of field is null?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related