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
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.