I have a multiselect text data element (listbox) on a form that stores data in a main table. From this main table (and only this table) I have a query that correctly displays the multi-select objects as text. However, when I add the field into a report, using only the query based off only the main table, the field displays only the key code values and not the text as displayed in the query.
The report defines the query as the record source. I have defining the field source property as the query, the main table, and the linked table without success. I have defined the SQL from the linked table and also from the query without success. I have also removed the field, saved and then readded the field thinking it might be corrupt, but none of these attempts were able to change the code to text in the display.
Have not used multi-select list box before. Is there something that I need to define differently in order to get the selections to display as text on the reports?
HELP.
The report defines the query as the record source. I have defining the field source property as the query, the main table, and the linked table without success. I have defined the SQL from the linked table and also from the query without success. I have also removed the field, saved and then readded the field thinking it might be corrupt, but none of these attempts were able to change the code to text in the display.
Have not used multi-select list box before. Is there something that I need to define differently in order to get the selections to display as text on the reports?
HELP.
