Align microsoft access queries

Question

Each time I have to copy a query from MSAccess from a control's [record source] property and paste in notepad to align it just so I can read it.

I once used Ctrl+R to replace commas with newline characters but now forgot what the newline character is. Have you used this before, if so how can I get the newline character?

Better yet, is there a tool to auto align SQL from MSAccess or any of the Microsoft database tools.

Cheers.

Answer 1

This online service "pretty" formats SQL for you Pretty SQL formatter or you could try using the Notepad++ replacement for Notepad; this includes a facility to search and replace for "extended" characters and replace them with newlines.