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

microsoft access courses - data validation ms access

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Data validation in Ms access

microsoft access courses - Data validation in Ms access

ResolvedVersion Standard

Dave has attended:
No courses

Data validation in Ms access

Hi,

I wanted to know how to do data validation in Microsoft access 2002. Any tips on data validation for my Microsoft access database tables would be great.

Thanks
David

RE: Data validation in Ms access

Hi Dave

To do data validation correctly with Microsoft Access 2002, you really need to write some code within vba that will check the input from the forms and make sure that go through the rules that you have set. If they fail then you can display an message box asking the using to try again and explain the format required. Alternatively if you do not want to use vba, you can use a very basic form of validation known as an input mask. This checks that the input meets certain conditions, such as first letter of name is uppercase and the rest is lowercase, however if this is not set by the user, access will automatically convert it to the requirements of the input mask.

Hope this helps
David

RE: Data validation in Ms access

Very useful

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



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