Multivalue field and exporting to Excel

  • Thread starter Thread starter Jay Oken
  • Start date Start date
J

Jay Oken

When I have a Multivalue field in a query and use that query to export to
Excel I get the numeric value upon export rather than the text for the
field. If I view the query in Access it shows me the text of the selections
separated by a comma but upon export I only get numeric values. Anyone know
how to overcome this.

Thanks,
J
 
Just noticed that when I use the export on the Ribbon it works fine. Only
causes a problem using DoCmd.Transfer spreadsheet. Any suggestions?
Otherwise I will post this on the Modules board.
 
Back
Top