How to change font size in Query?

[Guest]

Hi,
This is a stupid question but I can not see clearly in my query, please help.
I selected a query, click on design and view in SQL, the font very tiny
....so how can I change it ? Thank you.
MN

 

[John Spencer]

I know of no way to do this in current versions of Access. If you really
need to work with it in a larger view, you can copy and paste it into a text
editor or word processor and work with it there. Once you have made the
changes, copy and paste back into the SQL view in Access.

Or try changing the resolution setting on your computer. Other than that -
perhaps the next version will allow you to control the font and font size in
the SQL window.

 

[Guest]

John,
Thank you for your reply.
Yeah, I tried copy and paste it. And wait until next version of Access?
MN

 

[LeAnne]

Assuming you're using Acc2K or later:

Select Tools | Options
Click on the Tables/Queries tab
Select your preferred query design font size (lower left side of window)
Click Apply

(Note: this will change the fonts in Design View as well as SQL view.)

Hope this helps,

LeAnne

 

[Guest]

Thank LeAnne,
I using Acc2K. I follow you instruction but I did not see "Select your
preferred query design font size (lower left side of window)" ? I don't know
why?
Regards,
MN

 

[LeAnne]

Whoops, sorry. That option is NOT available in A2K...at least, not
using the command path I suggested (which is present in Acc03, and
mighty handy it is, too). Guess you'll have to try John's suggestion
until you upgrade. :-(

LeAnne

 

[Guest]

Thank LeAnne.
MN

Whoops, sorry. That option is NOT available in A2K...at least, not
using the command path I suggested (which is present in Acc03, and
mighty handy it is, too). Guess you'll have to try John's suggestion
until you upgrade. :-(

LeAnne

 

[supercooper]

I'm runnning A2K, and I write my queries in Notepad 2
(http://www.flos-freeware.ch/notepad2.html), which formats .sql files
nicely. An incredibly powerful, yet extremely lightweight text editor
that formats files for all types of programming languages
also....highly recommended.

chad!