Solved Changing text box to combo box

Microsoft Excel 010 - complete package
July 2, 2013 at 11:51:11
Specs: Windows XP
I'm using 2010 and cannot find a way to do this. I see that earlier versions had a Change To on the Format tab but I see nothing similiar in Access 2010. Specifically, I need to change a field from a text box to a combo box so the user can select a 'Task Owner' from an already created table called 'PickList-TaskOwner'. HOW? It has to be something simple that I am just overlooking, right? I need this for a task at work so any help would be appreciated!

See More: Changing text box to combo box

Report •

July 3, 2013 at 01:12:35
✔ Best Answer
Hi GingerLeake,

If you right-click on the text box, you will get a dialog box that has a "Convert To" option.

Let me know if it helps.

Thanks & Regards
Manshu S

Report •

July 3, 2013 at 11:05:04
Well, good grief, I can't believe I never noticed that all the times I right clicked and eyed that long list. Thank you for telling me where to look, I found it and it's okay. Now I'm just trying to get it to use the second column instead of the first in the table to populate my field!

Thanks again!

Report •

July 3, 2013 at 11:54:09

In some scenarios, it may be easier to just remove the field and create a new one. By doing this you will get help from the wizard. The wizard will walk you through which field this combo box will affect in the DB, what table to use as the list of options as well as what data to display or use.

You can also change the column the combo box uses to populate the DB by selecting the combo box in design view, clicking on the data tab on the property sheet and changing the 'Bound Column' to whichever column you want to use (1, 2, 3 etc.)

Hope this helps!


Law of Logical Argument: Anything is possible if you don't know what you're talking about.

Report •

Related Solutions

July 5, 2013 at 10:16:47
Thanks, Newbie10! I'm about to post another question about 'bound' columns because I'm having an issue with one.

Report •

Ask Question