Default Font

  • Thread starter Thread starter Jeff C
  • Start date Start date
J

Jeff C

I export numerous queries to Excel but I cannot set the default font for them
to be exported in. Excel is set to the same default font as Access but each
exported query always ends up MS Sans Serif rather than the set default.

Where do you set the font for exported queries?

Thanks in advance.
 
On Wed, 10 Dec 2008 06:35:01 -0800, Jeff C

There is no built-in way to do that. If it really bothers you, you can
write some Automation code to format the report after the export is
completed.

-Tom.
Microsoft Access MVP
 
Thanks Tom - though not the answer I wanted it saves me continuing to search
through Access and Excel settings to find what I thought I had missed.

It adds multiple extra steps when building pivot reports is all
 
Back
Top