Can i export a report to Mocrosoft Word?

[Mota]

Hi;
I have a report containing a text box bound to a Memo field in its bound
table.Even when i set its Text Align Property to Distributed,I cant align
its text to both left and right.(Its fonts are of a Right To Left
language).It seems Distributed text align would not work with other
languages and causes to align text to left.In word we can simply do this
using Shift+Enter.
For this reason,Im looking for a way to export this report to MS Word and
print it there.Is this possible thru code?
Thank you in advance for ur help.

 

[Jeff Boyce]

No code necessary.

Open your report. The toolbar should include a button for exporting to
either Word or Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mota]

Thats fully true.But for our amateur users,that dont have access to Access
Toolbar and MenuBars,its better to have a command button to do it for
them.Can you help me write this code snippet?
Thank you for your attention and help.

 

[DanielS via AccessMonster.com]

You can use the Following:

DoCmd.OutputTo acTable, "tblBillingInfo", "RichTextFormat(*.rtf)",
"MyExtract", False, "", 0
or create a macro using the outputto action.

Daniel S.

No code necessary.

Open your report. The toolbar should include a button for exporting to
either Word or Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi;
I have a report containing a text box bound to a Memo field in its bound

[quoted text clipped - 6 lines]

print it there.Is this possible thru code?
Thank you in advance for ur help.

 

[Jeff Boyce]

Mota

You hadn't mentioned using a custom toolbar. So how about if you add back
in the <Send to Word/Excel> toolbar button on your custom toolbar?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mota]

I dont have more things to put in that custom tool bar.But If there is no
way to use a button,i wd do that.Thank you Jeff.

 

[Mota]

Yes,Thank you.I would try this to export a report.

You can use the Following:

DoCmd.OutputTo acTable, "tblBillingInfo", "RichTextFormat(*.rtf)",
"MyExtract", False, "", 0
or create a macro using the outputto action.

Daniel S.

No code necessary.

Open your report. The toolbar should include a button for exporting to
either Word or Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi;
I have a report containing a text box bound to a Memo field in its bound

[quoted text clipped - 6 lines]

print it there.Is this possible thru code?
Thank you in advance for ur help.