Multiselect Listbox and Reports

[thatlem]

I have a multiselect listbox which is stored in a table. I then have run a query from that table and it accurately displays all the selected field items. (as descriptive text, not as numerical code). However, when I build a report and pull the query field into the report, it displays as the numerical key value, not as the descriptive text field.

Any suggestion would be appreciated.

Thanks

 

[lcook1974]

Is the table linked to another table in the query?

 

[thatlem]

No it was only linked to the one table.

Decided to remove the field, save and then add again... and it worked.

Odd... but it worked.

thanks for the help.