Restrict entering Null or Empty in Textbox - Access 2007

Sep 16, 2014
Reaction score

I'm developing small database to enter plan no for the company.

The Primary Key is Plan_No and entered using a form (unbound text box -> txt_plan_no)

I want to restrict empty or null in the txt_plan_no before go to the next textbox Customer Name.

I use the following coding. It gives the error message box but it always go to the textbox Customer Name without staying focus in txt_plan_no

Private Sub txt_Plan_no_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Or KeyCode = 40 Or KeyCode = 9 Then
'13-enter key|40-down arrow | 9-tab key
If IsNull(txt_Plan_no.Text) Or IsEmpty(txt_Plan_no.Text) Or txt_Plan_no.Text = "" Then
MsgBox "Plan No. cannot be Blank!", vbCritical
End If
End If
End Sub

Please help.


:dance: CoolPra :dance:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question