Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Upgraded to office 2007

    I have just upgraded to Access 2007 and have 2 quick questions:
    How can I reformat the text on the SQL query page?
    Once a few tables and queries are open, they tend to get hidden behind each other. Is there a way of quickly stepping through the open sheets until I reach the one I need?

    Thanks
    Alex

  2. #2
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post
    Instead of stacking everything up, you might use “Tabbed Documents,” go to Office icon at top. At bottom of menu, choose Access Options | Current database and the radio button for Tabbed Docs.tabbed_doc.bmp

    Don't understand about reformatting the SQL text. Looking for another font?
    Alan

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by pergunas View Post
    Once a few tables and queries are open, they tend to get hidden behind each other. Is there a way of quickly stepping through the open sheets until I reach the one I need?
    The Switch Windows command is on the Home tab, and lists all open windows.
    I use that a lot so I have added it to the Quick Access Toolbar
    switchwindows.gif


    Can you explain more what your issue is with the format of SQL. I don't remember it being any different from previous versions, but it is a while since I used 2003.
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the replies - I will try out the suggestions so far made

    I am just looking to change the font size in SQL

    Alex

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    If you go into Access Options - Object Designers page , you can change the font size for Query Design.
    SQL view uses the font and size you select.

    SQLFont.gif
    Regards
    John



Posting Permissions

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