Access 2007 VBA and Report Print Preview

[Tony1949]

I am developing a test bed for my Access 2007 application and wish to export various reports in txt format so I can perform a simple automated file comparison to detect any differences between the current and previous versions of the reports.

I can successfully export the reports in txt format, but I wish to make one further refinement. When viewing the report in Print Preview mode, there is a Print Data Only option in the Page Layout group. Is it possible to access this option from within VBA?

Thanks for any help you may be able to offer.

 

[ajetrumpet]

Tony,

I don't know about this, but I have seen that option up there. That option only displays controls that have control sources (that's what the program considers to be "data", I guess). Maybe you could use .Visible or something to display the data based on weather or not each control has a CS...??