Text in Numerical field.

[D.W. Schingenga]

I have to make changes to an existing Dbase. Problem is that in this Dbase it is on one form possible to put text in a numerical field. I need to do this again, however it does not work, Access gives the message that Text will not go in a numerical field. I am talking about a combobox.

What appreciate some tips how to get this done.

Thanks,

Dirk

 

[Mile-O]

Change the Numerical field to Text - it's all you can do.

 

[D.W. Schingenga]

I know that solution, but the existing DBase is using the same table as I am going to use for the form. Is must be numerical. The field is customernumber, which we choose by a combobox, the combobox is build from a query in which is the customernumber, name, address. If you choose the desired customer, I just want to show the name and not the number in the box after selection.

Dirk.

 

[Mile-O]

Set the ColumnCount to as many fields as there are in the combo's RowSource. Set the ColumnWidths as appropriate (i.e. 0;2;0;2 ) where 0 is a hidden field.

 

[godofhell]

To add to SJ MCAbney, comment. Make sure you set your bound colum to the colum containing the customer number and not the date or you will get errors. Doing the suggestion McAbney suggests will allow you to display the name without the user knowing that the field is actually storing the number.

 

[D.W. Schingenga]

Thanks for the help, works fine.