access+course - validation

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


 

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.07 secs.