asked on
Description displaying on Report
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'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.
Microsoft Access
Last Comment
gcgcit
Agreed with @fyed.
I saw your first question a little earlier.
Create a subreport object!
It's not hard. Add a new report in design view, open your subform in design view
Copy all the objects from the subform, paste them on the the report.
Open the recordsource of the form, Save as a new query.
Tweak it. Every combobox on the form can be a join in the report query and then just a textbox.
Although some Experts have disagreed with my adamance, reports are for printing, forms are NOT
I saw your first question a little earlier.
Create a subreport object!
It's not hard. Add a new report in design view, open your subform in design view
Copy all the objects from the subform, paste them on the the report.
Open the recordsource of the form, Save as a new query.
Tweak it. Every combobox on the form can be a join in the report query and then just a textbox.
Although some Experts have disagreed with my adamance, reports are for printing, forms are NOT
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I just started using 2007 - that was pretty easy to convert to a report so I did. Looks great. Thanks guys!
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.