Best approach to summarising a lot of debug.prints back to the user?!

[peskywinnets]

I have some code that traverses though a database, does some calculations on the data & then summarises what the user needs to do.

While debugging this, it was just a case of using the immediate window debug.print, which gave a summary of the progress line by line. How can I summarize (in other words collect all the outputs of the debug.print I've been using & dump into one file & outputting that back to the user).

I can't simply (easily) use a message window & concatenate variables as there are times where loops are used t extract data.

My immediate thought is to write all my debug.print output to a text file then output that text file onscreen?

 

[plog]

You could make an unbound Form and populate a control on it with the text. You could feed it to a database and spit it out on a Report.

If you could explain the context a little better (sample of this text, what actions the users would have to take, etc.) that may help.