Export to Word gridlines

[Steve54]

Hi
I’m working with, Word 2003 and Access 2003, I’ve exported a report from
access, to word, and the gridline formatting do not show up in word document.
Can anybody help in this area?
Thanks
Steve

 

[Armen Stein]

I’m working with, Word 2003 and Access 2003, I’ve exported a report from
access, to word, and the gridline formatting do not show up in word document.

Hi Steve,

That's because Access doesn't output to native Word format, instead it
uses RTF. Everything is separated by paragraph markers and tabs. Use
Show/Hide (the backwards P button, or Ctrl-*) to see what I mean.

If you want a true Word document and control the formatting better,
you would need to build a Word merge from a table or query, or for
even more control (and difficulty), automate Word using VBA code.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Pete D.]

Armen gave you good ways, and you can also in word select tables, convert
text to table using the tab as the delimiter to change it back to a table.
If all the tabs are right it should work but only testing will tell.

 

[Steve54]

Peter
Your instruction work perfect, I did testing very thinks work just the way I
expected. Some how, I must miss it during all my training. I’ve spent a lot
of time in trying to figure this out.
Armen’s instruction is a little more advanced, but I’m willing to try, now
if can fined the code.
Thanks Again
Steve54