Output to Word

[DAve]

I am using the following code to output to word

DoCmd.OutputTo acOutputQuery, "qryResult", acFormatRTF, strFileName, True
which works fine but I have two questions

1. Is there anyway that the word document that opens, opens in landscape
rather than portrait

2. I cant figure out how the widths of the columns are determined in the
word document - are they based on the field length/type? or something else?

 

[Tom van Stiphout]

On Tue, 29 Sep 2009 15:16:03 -0700, DAve

Maybe you would have better luck if you used a Report rather than a
query. Then use DoCmd.OutputTo acOutputReport.

-Tom.
Microsoft Access MVP