I needed to write some Pass Through queries to an SQL server. So I thought I would write the SQL in SQL Server Management Studio and then just paste the SQL text into Access when I got it where I needed it.
However, once you do that I can't edit any of the text. If I click some where and try to Backspace or delete and does all kinds of crazy things. It looks like it deletes but then when I type something it pops in characters again. Some times it backspaces at the wrong place.
I'm using Access 2003. Has anyone else seen this or am I going (more) insane.
I tried that and it still doesn't work. I was wondering if it had something to do with the character set encoding. I was thinking about pasting the text into a form and running some code on it to pull out the non-printable characters so it would then paste correctly or have the form create the PTQ on the fly. Any thoughts?