State code

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

If I make a field in a table "State" how can I limit it to only state
abbreviations. Is there a code for this rather than actually creating a
table and entering all the state abbreviations?
 
ladybug via AccessMonster.com said:
If I make a field in a table "State" how can I limit it to only state
abbreviations. Is there a code for this rather than actually
creating a table and entering all the state abbreviations?
Click to expand...

You can limit the length of the entered text to 2, but if you really
only want to accept valid state abbreviations, you'll need to have a
table of the valid values. Then you can use a combo box on a form, with
its Limit To List property set to Yes, to allow the user to enter or
choose only values from your table of states.
 
ladybug via AccessMonster.com said:
If I make a field in a table "State" how can I limit it to only state
abbreviations. Is there a code for this rather than actually
creating a table and entering all the state abbreviations?
Click to expand...

I'm sure you can download a table of states and their abbreviations from
the web, probably from http://www.usps.com/ .
 
Back
Top