form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I made a form, now how can I set a form like user have to fill field, or
the form will not go forward.

Thank you
 
You can use the before update event of the form to check if the fields are
filled, if not prompt a message and stop from going forward

Something like

If IsNull(Me.[TextBox1Name]) Or IsNull(Me.[TextBox2Name]) Then
MsgBox "Fields must be filled"
Cancel = True ' Wont let the user to continue until the fields are filled
End If
 
You must log in or register to reply here.

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

Similar Threads

Outlook Creating an Outlook form 2
Create Fillable PDF Forms With LibreOffice Writer 3
How to calculate the age in a particular month? 0
Opening form and going to a specific field in the middle of the from 1
Test form for changes on close 6
required field in form 3
Check Data before Saving. 2
Confused about where to put code 9

Back
Top