Default Font

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.
 
T

Tom van Stiphout

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
 
J

Jeff C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export from Access 1
Default font when exporting to spreadsheet format 3
Satan joke 6
Run a form in background using checkboxes on main form 0
Access MS Access run a form in background 0
Default font in MAPI invoked email 3
Error upon exporting results of query to text file 1
Transfer Spreadsheet into Excel 5

Top