Multivalue field and exporting to Excel

[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

 

[Jay Oken]

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.