Maybe a simple one. I have quite a lenghty and complex WHERE statement in my Access Query. For the sake of readability and following the logic without eyestrain, I would like to be able to show it on several lines with breaks at logical points. I save the query after putting in the line feeds (using the Enter key) and at this point it looks fine. When I re-open the query it loses all the line feeds and the statement appears as before, concatenated and wrapped over.
I'm sure it can be done as I've done this before albeit some time ago on mainframe SQL and I've seen it on an sample Access database query I've recently downloaded from a website. A test query I wrote in the sample database does it fine, but not in my database. I have only been using Access 2007 for about a month now so not familiar with where all the settings, switches etc. are so any help here would be much appreciated.