must use outputto or something other?

[ssh]

How can I retrieve customized contents text output file when to click button? @ the moment I use DoCmd.OutputTo acOutputQuery, "myQuery", acFormatTXT, "96.txt", True

 

[AndyS48UK]

Do you mean a formatted output?

You could use the query fields on a report and then use the same command (but acOutputReport I believe) to a Rich Text Format (rtf) file. Access won't output any boxes and borders though.

 

[ssh]

Hmm, I'll give a try. If something will go different then I will let know.