Why is my report showing ID instead of text value

[crich21]

Could someone please take a look at this db and tell me why I am having the problem of the report showing id values instead of the names related to them. I have tried everything I can possibly think of and I must be missing something very little.

Thank you in advance.

 

[crich21]

Just to clarify I am have problems with the takenby and approved by fields on my report. Just run the report and you will see what I mean.

 

[samonwalkabout]

Its showing numbers as the data is numbers!

If you need the number value to represent a name you need to relate it properly or use a combo box on the form. I presumed you meant Employee name so i changed the textboxes to combo's and made them lookup the names in the table. Format set to 2 columns, (0,1) so only the name is shown.

Give it a look, I couldn’t get the report to open due to missing DLL on my machine.

Sam

 

[Pat Hartman]

Comboboxes don't belong on reports. Use a query as the recordsource for the report and in the query join to the lookup table. That way, you'll have both the key value and the description value available and your report can show either or both.

 

[samonwalkabout]

Pat, i know your always right and bow to your wisdom but can you tell me why? (Looks like today could be spend removing combo boxes from reports)

 

[Rich]

Reports are not user interactive, so there's no point in having combos on Reports, or in tables either for that matter which is probably why they're appearing on your report.

 

[samonwalkabout]

I use them as im limited to qrys of 255 fields so a few combos here and there allow my complex reports to work and they dont show as combo's on viewing the report..ie the little arrow on the righthandside don't appear.

 

[Rich]

255 fields

 

[samonwalkabout]

Thats what comes from promising users what they want...not what they need