State code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ladybug - 07 Mar 2007 20:10 GMT

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?

Reply to this Message

Dirk Goldgar - 07 Mar 2007 20:26 GMT

> 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?

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Dirk Goldgar - 07 Mar 2007 20:27 GMT

> 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?

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

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message