OutputTo to Word

[Jose Perdigao]

I'm using docmd.OutputTo command to export data from a view or store
procedure to Word.

The procedure is simple and the final result; we have the data in word as a
table.

I have two questions.

1. How can I format programmatically the page format from portrait to
landscape?
2. How can I increase programmatically the width columns

In access ADP if I increase the width column doesn’t save, next time, when I
open it the width is the same.

Thanks,
JP

 

[Kevin Jameson]

I'm using docmd.OutputTo command to export data from a view or store
procedure to Word.

The procedure is simple and the final result; we have the data in word as
a
table.

I have two questions.

1. How can I format programmatically the page format from portrait to
landscape?
2. How can I increase programmatically the width columns

In access ADP if I increase the width column doesn't save, next time, when
I
open it the width is the same.

Thanks,
JP

 

[John Nurick]

As far as I know you can only get this kind of control by writing VBA
code that automates Word and manipulates the page setup and the Word
table. This
http://word.mvps.org
is a good place for information on Word.