Form Values Showing as 1, 2 3 etc in reports

[claddagh]

Hi Guys,

I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for.

I have a table which is use for a drop down list in my forms.
This is saved into a table, but shows up as a numerical instead of the name value.

Also In reports, I get a numerical value, instead of the text value.

Is there something I`m over looking ?
Or am I doing something totally wrong.
My relationships are correct. and the field data is right, I just cant over come the number issue.

Thanks in advance.

 

[Mile-O]

First of all, don't use a table for anything other than storing data in. If you want to display the items in a table in a combobox then use a query - at least in queries you can manipulate the data (such as sorting it). Anyway, check the ColumnCount property of your combobox and set it accordingly.

 

[Jibbadiah]

Presumably your list box has more than 1 column.

Look at your list box in Design view.
Look at "bound column" from the data tab.
Set this to be the column info that you want to save.

It has probably defaulted to 1. Try setting it to 2 and see if that resolves your problem.

 

[claddagh]

Thanks Guys

Thank you for your help.

This looks as though it will fix my problems.
I`ll report back once I`ve implemented the changes.
Thanks again for the prompt responce.

Max

 

[claddagh]

No luck

Thanks for the prompt responce guys.

I have tried the above but i`m still having problems.

I have a table with the ID 1 - 7 etc.
Nect to the ID is a text value, eg, Supplier name 1 = Protec, 2 = Hurst 3 = Scotplas etc etc.

When I view my data in the form, it displays perfectly.
When I look in the table it is represented by the numeric value.
When I view this data in a report, I get the numeric value instead of the text value, but the numeric value DOES correspond to the correct field im looking for.

How can I change this in my reports so that the text value is displayed instead of the numeric value.

I hope I have made myself clear on this, as I`m crap at this sort of description.

Thanks in advance for any help guys.

Max

 

[Rich]

Look at the post from Pat, she's already told you how