Whenever I export a table or query to Excel, the data in the Excel file is in MS Sans Serif, which is difficult to read. How can I change the default font that's used in the export. I would like the data to be in Arial font.
Thanks,
jr
Default Font for Export to Excel
Advanced Beginner
Windows XP 
Access 2007
Whenever I export a table or query to Excel, the data in the Excel file is in MS Sans Serif, which is difficult to read. How can I change the default font that's used in the export. I would like the data to be in Arial font.
Thanks,
jr
VIP
Windows 7 64bit Access 2010 32bit
This is a format setting in Excel. Probably requires opening the Excel file as an object in VBA in order to manipulate properties of the sheet.
Or go set the desired font as default in Excel application. Does that affect the export?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows XP Access 2007
Actually, I found that you need to go into Access Options and change the Datasheet Default Font.
VIP
Windows 7 64bit Access 2010 32bit
Great! Learned something new. So the font format set in Access is carried over with the export. Nice to know.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Export to .pdf with default name
Posting Permissions
Reply With Quote