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

access+course - access data

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

access+course - Access 2003 Data Validation

ResolvedVersion Standard

Steve has attended:
Access Introduction course

Access 2003 Data Validation

When entering a record, can I format a field so that the entered information (in this case it happens to be a part number) cannot be a duplicate of an existing entry in that particular field? If so how? Null entries must be permissable however.
(NB The purpose being to avoid someone duplicating an entry at some point in the future.)
Thanks.

RE: Access 2003 Data Validation

Hi Steve,

Thanks for the question.

One way of restricting duplicates is in the design view of the table click into the field you want to restrict. In the Field Properties section make sure the General tab is highlighted and use the Index option at the bottom, change the Index to Yes (No Duplicates). This will flag up a problem if you want to keep entering 0, you could try setting the Required field to "No" and not entering any data instead of putting a 0.
Tracy

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.