May 15, 2003 #1 sarahjane28 IS-IT--Management Joined Oct 23, 2002 Messages 14 Location US Does anybody know the VB code to print a report to a txt file? Any help would be appreciated : ) Thanks, Sarah
Does anybody know the VB code to print a report to a txt file? Any help would be appreciated : ) Thanks, Sarah
May 15, 2003 #2 shannonp IS-IT--Management Joined Nov 13, 2001 Messages 289 Location NZ I don't think you can print a report directly to a text file. You can, however, print data within a report to text. Upvote 0 Downvote
I don't think you can print a report directly to a text file. You can, however, print data within a report to text.
May 15, 2003 Thread starter #3 sarahjane28 IS-IT--Management Joined Oct 23, 2002 Messages 14 Location US Doyou know the code to print the data to a txt file? Thanks, Sarah Upvote 0 Downvote
May 15, 2003 #4 shannonp IS-IT--Management Joined Nov 13, 2001 Messages 289 Location NZ Try this: DoCmd.OutputTo acOutputReport, "MyReport", acFormatTXT You could put this in a function or bound to a command button 'on click' event. Hope all goes well Upvote 0 Downvote
Try this: DoCmd.OutputTo acOutputReport, "MyReport", acFormatTXT You could put this in a function or bound to a command button 'on click' event. Hope all goes well