drop down lists and reports/exports

[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!

 

[Klatuu]

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?

 

[S.Clark]

Using MultiValue?

 

[kraus012]

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.