How do I make a # be a text field importing from Access into Xcel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a Macro in Access to "Output to" Excel using an Object type of
"Report". there is a numeric field that needs to be a Text field in Excel
but Excel is automatically making it a numeric field. It is a Text field in
Access. Is there a way to ensure it stays a Text field in Excel?
 
Patti,

In the query that the report is based on, you could try forcing the data
to be a string via the Format function. For example...
FieldToUseInReport: Format([YourExistingField])

Don't know if it will help, but worth a try...
 
Back
Top