long sql string

[tmort]

I have a long SQL string that I had to piece together over several lines. The code isn't working right so I figured I have done somthing wrong as it works with a shorter simpler SQL string.

The string doesn't all fit in a msgbox for viewing and comparing it to what I want. How can I view the entire string or print it to the screen.

Thanks

 

[ShiftyJaffa]

after your string is made up assuming strMySQL is your string, try Debug.Print strMySQL. Then bring up the debug window (CTRL G) and copy and paste the string into a new query (SQL mode) which may help find your problem.

 

[WayneRyan]

tmort,

You can also (temporarily) put an unbound (no control source) textbox on
your form called txtDebug.

Then in your code:

Me.txtDebug = TheVariableThatHasYourSQL

Wayne

 

[tmort]

Thanks, I did the second method. There were some issues with getting #s around some dates coming from forms coupled with a typo