O/T Database constraints?

A

airtj

Charter Member
Does any know how to add a constraint to a field in Microsoft Access 07? I'm taking a course in college on database management. I've looked on the internet but haven't found any examples for Access. For example a zip code requires 5 digits and if you enter more it will reject the numbers.

Thanks for your help
 
The range of US zip codes runs from 10001 through 99950, so your rule would look like this:

>= 10001 And <=99950
 
airtj said:
Does any know how to add a constraint to a field in Microsoft Access 07? I'm taking a course in college on database management. I've looked on the internet but haven't found any examples for Access. For example a zip code requires 5 digits and if you enter more it will reject the numbers.

Thanks for your help
Click to expand...
Use the Input Mask for a table field. :jump:

--WH
 
You must log in or register to reply here.
Back
Top