ABC Blocks

ABCDataworks

Database and Website Design, Development, and Deployment--All in the Service of Your Mission

In response to a question about whether or not it is possible to change the font size of the SQL viewer in Access (No, unfortunately), we created a form that will let you edit the SQL of any query, whether it is stored as a query in the database window or as a string in a form or report. Because it happens on a form you can change the font and size quite easily. While there is a gain to be had in the easy access to SQL behind forms and reports, there's a loss of functionality--if you have an error in your SQL Access will not highlight the problem spot for you, as it does in the SQL viewer, though it will give you accurate error messages.

This was written in Access 97 and converted to Access 2000.

Access 97 mdb file

Access 2000 mdb file