access+course - validation

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

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

access+course - Validation

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Server loaded in 0.09 secs.