Combo box is recognized as digit format

[Gealeks]

Hi! i created combo box in a Form taking data from a related table. But it doesn't let to choose the data from drop-down list saying that the entry doesn't match to the field format, meaning that i try to put text data into digit format field. I checked several times, the linked source table has text format. But the the combo box in the Form behaves as a digital format. How to fix it?

[drunkenneo]

best way is to relate the combo with a query.

[June7]

What is data type of the field you want to save data into? Probably number.

What is the type of data selected in the combobox? Probably alpha text.

What is the RowSource of the combobox?

Here is a tutorial of what neo described http://www.datapigtechnologies.com/f...combobox3.html

[Gealeks]

Hi June7. Thanks for quick respond! I'm afarid the type of the combobox is number (while type of the related table column is text), but I haven't found where I can change the type of combobox. So that's the question - how to change its type?
Entered data is text (it should stay a text).
The Raw source of the combobox is Querry.

[June7]

Did you review the tutorial? The last example is what you want to do.

[Gealeks]

Hi June7. Thanks Yes I did and recieved another problem All entries in the column now change depending on the data entered in any raw.

[June7]

That's because it is an UNBOUND control. Set the combobox ControlSource property to the field you want data saved in.

[Gealeks]

Hi June7. Sory for boring questions, but after setting the Control Source to a proper field, system doesn't let to put text data into cell, while the related column has certanly the text format. How it can be solved?

[June7]

Use multi-column combobox http://datapigtechnologies.com/flash...combobox3.html

The combobox BoundColumn will be the column with the ID and the ID will be saved to field set in ControlSource. The ID column will be hidden and the company name column will display for users to choose.