Is there a easy way to convert all text fields to combo box( to add drop downs)

[stalk]

I have 6 forms and about 60 fields( currently they are text boxes) that I need to add drop down to prevent formatting issues during data entry.
Any suggestions are greatly appreciated.
My plan is to add all the drop down values for all the fields in a excel spreadsheet and then import that table then link each combo box with relevant field.

open to any best solutions to quickly modify the fields



Thank you

[orange]

What do you want to accomplish in plain English --no database jargon?
What is the application in overview?
Why is Excel involved?

Need some context to offer suggestions.

[ranman256]

right click on the textbox, convert to combo
set the combo data source.

[Gicu]

You can also do the conversion in VBA (you will need to open the forms in design view and loop through the controls checking for the ControlType=acTextbox):
https://www.tek-tips.com/viewthread.cfm?qid=943635
But your plan with setting the row sources will not work, depending on your field contents you will need one new lookup table for each entity like a table of cities for a City combo, a table for street type (Street, Avenue, Road,...) and so on. Doing that in Excel will not help you much as you cannot set the row source using a range like in Excel.

Cheers,