Converting edit box to value list

[Scott_R]

Hello. I have a largish (30k record) database.

One of the fields is an Edit Box set to auto-complete with previously entered values.

I'd like to be able to make this a popup list, if possible. My concerns are:

1) optimally, I'd like to be able to retrieve the autocomplete list and populate the value list with it. Possible?

2) I'm concerned about what might happen to the existing records. Not all 30k records are populated in that field (I'm adding information to existing records as I get it). More importantly, I don't want those fields already filled to get messed up by fiddling with the setup.

Will I basically have to create a near-duplicate of this field but in its desired form, attempt to copy records from the original, and then delete if all works out or is there something simpler?

[Christian Marks]

Hi Scott,

I think all you need to do is: Create a new value list -> Select use values from field -> Specify the field in question. Then attach that value list to the field on the user-accessed layout.

If you still need a static list of the values, follow these steps:

1. Show All Records

2. Sort by the Field

3. Export -> Group By the Field -> Export the Field

In regards to disturbing old data, this should not be a worry, as adding a value list to a field will not interfere with any previously entered data.

HTH,

Christian