Look up

[cmfog]

I have a field in a table where it is a lookup is a combo box. So this makes the data type of the field a number when in reality it is a text. When I have this field show in a list box it shows the number instead of the text. Does anyone know how to fix that

 

[jdraw]

Most would advise you NOT to have a lookup in a table, but it is unclear from your post exactly what you have. I may be misunderstanding your set up.

Please see this for more info.

 

[cmfog]

I guess to make it easier. How do you show the text values instead of the numerical place values from a field in a list box

 

[vbaInet]

Based on your last thread about Listboxes I think you mean you would like to hide the bound column of the listbox. Did you manage to look into the Column Counts property? You can make any column hidden using that property.

 

[MSAccessRookie]

If your Listbox it based on just the Table, it may not be able to see the Text that is displayed inthe Combo Box, and should not be used as the Source for the Form. If that is the case, then you can create a Query that JOINs the Table in Question with the Table containing the Text that you want to display, and make that the Source for the Form instead.

This issue is just one of the reasons that you should consider not using Lookups in your Tables.
-- Rookie

 

[jdraw]

cmfog,

Your question stated combobox and listbox --here's more info on comboboxes

Good luck.