.snp files...specifications in VBA

[Andre Laplume via AccessMonster.com]

I want to output an MsAccess report as a .snp file as oppesed to a .rtf
file due to inheret issues with .rtf formatting. How do I specify this in
my DoCmd Output statement. Right now I use:

DoCmd.OutputTo acOutputReport, "MasterDeptList", "Rich Text Format", "X:\
....\filename.rtf"


What goes in place of "Rich Text Format" for a snapshot file?

 

[Van T. Dinh]

It may depend on the Access software version (?) but try:

acFormatSNP

for Snapshot. For Rich Text Format, the equivalent is:

acFormatRTF

 

[Andre Laplume via AccessMonster.com]

THANK YOU!