Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    changing the SQL view font (2002 SP2)

    Anyone know if it's possible to change the font used in the SQL view for queries?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: changing the SQL view font (2002 SP2)

    Since queries are normally behind the scenes, why does the font matter? In any event, there is no way within Access to change the font for queries.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing the SQL view font (2002 SP2)

    I think you misunderstand my question. I am editing the SQL and I want to use another font for doing so.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing the SQL view font (2002 SP2)

    Thanks Mark.

    Unfortunately I am using Access 2002 <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: changing the SQL view font (2002 SP2)

    The answer is Yes - if you are using Access 2003. From MSKB 823089 How to use the new features and the new enhancements that are in Office - Access 2003:
    <hr>Change the font for Query Design view and for SQL view
    In Access 2003, you can change the font that you use in Query Design view and in SQL view. To change the font, follow these steps:
    1. On the Tools menu, click Options.
    2. Click the Tables/Queries tab.
    3. In the Query Design Font group, select the font and the font size that you want.<hr>
    If using Access 2002 or earlier, buy some eyeglasses or a magnifying glass & squint a lot, then maybe you can read the SQL View typeface w/o going blind.... <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15>

    HTH

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: changing the SQL view font (2002 SP2)

    I might add that since the SQL string you are working with is plain text, it is pretty easy to copy and paste it into Word and then change the font. Another trick is to paste the string into a form as the data source and then use the zoom feature (SHIFT-F2) where you can change the font. Not as nice as 2003 though.
    Wendell

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing the SQL view font (2002 SP2)

    I've started using the copy and paste method using Visual Studio .NET as the editing app since that recognises and colour codes the SQL for me, so much better than the plain black and white editor in Access anyway.

    Does Access 2003 colour code the SQL?

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing the SQL view font (2002 SP2)

    Access 2003 does not colour code the SQL. Do you have one of the inexpensive "advanced" Text Editors? If you can get one, you should be able to set up a custom class for editing SQL. In any event, if you work heavily in SQL View, using a Text Editor has the benefit of being able to store your work in memory. HTH
    Gre

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: changing the SQL view font (2002 SP2)

    Like I say, I'm using Visual Studio .NET.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •