Convert Combo Box to Text Box

[zool]

Hi,



Is it possible to convert database which have multiple values(combo box) into text box(single value) inside a form?

Zool

[June7]

Form in design view, select the combobox, right click, ChangeTo. What happens when you try that?

[zool]

June7,

Thanks! sorry i didn't try it earlier and somehow it works. Lets say, it doesn't display data that i want (i.e displays random number instead of actual data) what should i do? This happened when i tried to convert it from combo box to text box in previous attempts.

[June7]

Can't be a random number, it means something. Did you have the field in table set up as a combobox with Lookup? Now that it is a textbox it shows the actual field value because textboxes don't have a RowSource property used to create Lookup. The actual value is from the key field of table the combobox Lookup used. Have to build a query that joins the tables on the pk/fk fields so all related data is available. At least, that's my best assessment without seeing the db.

[zool]

June7,

Thanks for the explanation. This really should clear anything that i might missed.