Look-up Fields

[Lester]

When you set-up a look-up field with X-amount of values in
it, can you sort these alphabetically? If so how?

I have a lot of values to enter into a look-up field but I
don't have the information alphabetically.

TX for any help.

 

[tina]

before you put a lookup field in your table, recommend you read the article
at the following link:

http://www.mvps.org/access/lookupfields.htm

hth

 

[John Vinson]

When you set-up a look-up field with X-amount of values in
it, can you sort these alphabetically? If so how?

I have a lot of values to enter into a look-up field but I
don't have the information alphabetically.

TX for any help.

Don't.

Instead, use a Form with a Combo Box; base the Combo Box on a Query
sorting your data alphabetically.