Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access+course - validation

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course - Validation

access+course - Validation

ResolvedVersion Standard

Nicholas has attended:
Access Intermediate course

Validation

How do I set up data validation on an input?

Microsoft Access Data Validation

Hi Nicholas

I trust that you enjoyed your Access Course.

There are two methods of data validation, the first you can carry out in the design view of Microsoft Access, thus go into design view and when you click on one of your entries you will see in the table at the bottom of the page, a row that says validation, within this row you can enter your validation.

The other options are that you can write some VBA or VB code to handle the data validation.

Hope this helps
David

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.