drop down lists and reports/exports

  • Thread starter Thread starter kraus012
  • Start date Start date
K

kraus012

I'm fairly new to Access 2007, and I'm having an issue with drop down lists.
I have a drop down list with 3 choices (done to avoid data entry errors).
When I create a report that includes this field, all 3 options show up in the
report where the one I've chosen during entry is highlighted. When I go to
export my report into Excel, the cells for that field are completely blank.
How can I change this so that only the option I've chosen shows up in both
the report and the Excel export?

Thank you for your help!
 
Are you using a Combo Box or a List Box?
Can you post the record source for the report and the control source
expression that causes the 3 values to show on the report?
 
I think it's a list box. Are you referring to the control source and record
source from the design layout? I'm not a programmer, just an Access user, so
I'm not sure exactly what you're asking for.
 
Back
Top