I have a field that is a listbox on the form. It stores the CODE but displays the DESCRIPTION.
I'm making a report, for this field, I want to display the DESCRIPTION but the report field is showing the CODE (because that's what's stored in the field).
On the report, I turned the field to a list control on the subform (which sits on the report), linking to that list and it's displaying the DESCRIPTION but it's also showing the dropdown arrow from the list... how do I make the data display in a textbox or get rid of the arrow on the list since this is a report.
I don't know of anyway you can programmatically change the control type of a control on the subform that is embedded in your report.
If you create a report, I would join that field "Code" to the table that is now the rowsource of your listbox, then I would add the [Description] field to the query that is the recordsource for the report.