Check for Null

[Guest]

I've got this code in the After Update event of a text box:

If IsNull([BusUnit]) Then
MsgBox "You must enter a BU.", vbExclamation
Cancel = True
End If

BusUnit is a text field with Allow Zero Length property set to No. I would
expect if I tab past the text box, the AfterUpdate event would fire and I
would get the MsgBox. Nothing is happening. What's wrong?

 

[Allen Browne]

The AfterUpdate event of the control does not fire unless the user actually
updates the control.

In any case, you cannot use the control's event to prevent null. You have no
way to know if the user will ever visit the control.

Instead, use the BeforeUpdate event of the *form*

Or, if you don't want to write code, just open the table in design view, and
set the field's Required property to Yes.

 

[Guest]

I did set the fields required property to Yes, and the Allow Zero Length
property to No. That works, but what I was hoping to do was to catch the
error immediately after the user tried to leave the control instead of
waiting until trying to commit the entire record.

I did try using the Before Update event of the form. That catches the error
and displays the MsgBox, but again, I was hoping to notify the user of the
error earlier in the process. Is that even possible?

The AfterUpdate event of the control does not fire unless the user actually
updates the control.

In any case, you cannot use the control's event to prevent null. You have no
way to know if the user will ever visit the control.

Instead, use the BeforeUpdate event of the *form*

Or, if you don't want to write code, just open the table in design view, and
set the field's Required property to Yes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I've got this code in the After Update event of a text box:

If IsNull([BusUnit]) Then
MsgBox "You must enter a BU.", vbExclamation
Cancel = True
End If

BusUnit is a text field with Allow Zero Length property set to No. I
would
expect if I tab past the text box, the AfterUpdate event would fire and I
would get the MsgBox. Nothing is happening. What's wrong?

 

[Allen Browne]

You could cancel the Exit event of the control.

It would be a rather frustrating interface though: being stuck in a control
and unable to do anything.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I did set the fields required property to Yes, and the Allow Zero Length
property to No. That works, but what I was hoping to do was to catch the
error immediately after the user tried to leave the control instead of
waiting until trying to commit the entire record.

I did try using the Before Update event of the form. That catches the
error
and displays the MsgBox, but again, I was hoping to notify the user of the
error earlier in the process. Is that even possible?

The AfterUpdate event of the control does not fire unless the user
actually
updates the control.

In any case, you cannot use the control's event to prevent null. You have
no
way to know if the user will ever visit the control.

Instead, use the BeforeUpdate event of the *form*

Or, if you don't want to write code, just open the table in design view,
and
set the field's Required property to Yes.

I've got this code in the After Update event of a text box:

If IsNull([BusUnit]) Then
MsgBox "You must enter a BU.", vbExclamation
Cancel = True
End If

BusUnit is a text field with Allow Zero Length property set to No. I
would
expect if I tab past the text box, the AfterUpdate event would fire and
I
would get the MsgBox. Nothing is happening. What's wrong?

 

[e.mel]

or you could just open the msgbox in the Exit event without cancelling
the event. that would tell them to enter a BU, but not force them to
.. . . until they try to save the record.

You could cancel the Exit event of the control.

It would be a rather frustrating interface though: being stuck in a control
and unable to do anything.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I did set the fields required property to Yes, and the Allow Zero Length
property to No. That works, but what I was hoping to do was to catch the
error immediately after the user tried to leave the control instead of
waiting until trying to commit the entire record.

I did try using the Before Update event of the form. That catches the
error
and displays the MsgBox, but again, I was hoping to notify the user of the
error earlier in the process. Is that even possible?

The AfterUpdate event of the control does not fire unless the user
actually
updates the control.

In any case, you cannot use the control's event to prevent null. You have
no
way to know if the user will ever visit the control.

Instead, use the BeforeUpdate event of the *form*

Or, if you don't want to write code, just open the table in design view,
and
set the field's Required property to Yes.

I've got this code in the After Update event of a text box:

If IsNull([BusUnit]) Then
MsgBox "You must enter a BU.", vbExclamation
Cancel = True
End If

BusUnit is a text field with Allow Zero Length property set to No. I
would
expect if I tab past the text box, the AfterUpdate event would fire and
I
would get the MsgBox. Nothing is happening. What's wrong?

 

[Guest]

That is a good solution. Thanks!

or you could just open the msgbox in the Exit event without cancelling
the event. that would tell them to enter a BU, but not force them to
.. . . until they try to save the record.

You could cancel the Exit event of the control.

It would be a rather frustrating interface though: being stuck in a control
and unable to do anything.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I did set the fields required property to Yes, and the Allow Zero Length
property to No. That works, but what I was hoping to do was to catch the
error immediately after the user tried to leave the control instead of
waiting until trying to commit the entire record.

I did try using the Before Update event of the form. That catches the
error
and displays the MsgBox, but again, I was hoping to notify the user of the
error earlier in the process. Is that even possible?


:

The AfterUpdate event of the control does not fire unless the user
actually
updates the control.

In any case, you cannot use the control's event to prevent null. You have
no
way to know if the user will ever visit the control.

Instead, use the BeforeUpdate event of the *form*

Or, if you don't want to write code, just open the table in design view,
and
set the field's Required property to Yes.

I've got this code in the After Update event of a text box:

If IsNull([BusUnit]) Then
MsgBox "You must enter a BU.", vbExclamation
Cancel = True
End If

BusUnit is a text field with Allow Zero Length property set to No. I
would
expect if I tab past the text box, the AfterUpdate event would fire and
I
would get the MsgBox. Nothing is happening. What's wrong?