Default font when exporting to spreadsheet format

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

When I export a table from Access to Excel format, the
default font of this file is MS Sans Serif font size 10.
Is there a way to change that value so the default font of
the exported file is Arial font size 8?
 
Change the font that the table is using to the desired font, and then export
the table. Export with "Save Formatting" option.
 
Thanks Ken,
Can this also be done via VBA code. Currently, I'm
calling the DoCmd.TransferSpreadsheet (acExport) function
to export the table.
 
The font change, to my knowledge, in a table cannot be done in code.
(Perhaps someone else knows of a way to do that.)

You would need to manually change the font setting in the table before you
run your code.
 
Back
Top