Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course - Access 2003 Data Validation
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+course - Access 2003 Data Validation
Resolved · Low Priority · Version Standard
Reply Thu 24 May 2007, 12:26Delegate Steve said...
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.
For upcoming training course dates see: Pricing & availability
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
|