Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-21-2019, 10:46 AM   #1
virencm
Newly Registered User
 
Join Date: Nov 2009
Posts: 60
Thanks: 2
Thanked 0 Times in 0 Posts
virencm is on a distinguished road
Preserve formatting when exporting from MS Access to MS Word

Hi,


Is there a way of preserving the formatting when exporting a report from MS ACCESS to MS WORD?


Cheers
V

virencm is offline   Reply With Quote
Old 10-21-2019, 10:48 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,901
Thanks: 57
Thanked 1,289 Times in 1,270 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Preserve formatting when exporting from MS Access to MS Word

Hi. Can you show us an example? Are you using OutputTo with acFormatRTF?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 10-21-2019, 10:51 AM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,027
Thanks: 115
Thanked 3,015 Times in 2,742 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Preserve formatting when exporting from MS Access to MS Word

No its not.
Suggest you do one of the following (from easiest to hardest):
a) export the report as a PDF (but this will be read only)
b) use a mail merge type export to a Word doc e.g. using Albert Kallal's super easy mail merge facility
c) create a Word template with bookmarks which the Access data is used to populate

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


I know that you know that we both know nothing
isladogs is offline   Reply With Quote
Old 10-21-2019, 03:29 PM   #4
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,851
Thanks: 36
Thanked 564 Times in 533 Posts
MajP has a spectacular aura about MajP has a spectacular aura about
Re: Preserve formatting when exporting from MS Access to MS Word

Although Isladogs solutions are probably your best bet, sometimes you can just "dumb down" your report. In other words if you can reduce the formatting and make your report simple, you may get a useable result. Converting to RTF is like a best guess, the simpler you make it the better the guess.

MajP is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting problem when exporting from Access 2007 to word doc alex_117058 Reports 9 01-11-2012 08:39 AM
Question Need help with text formatting or exporting to Word (retain formatting necessary)! hmoritz72 General 2 05-05-2010 08:00 PM
Exporting reports to Word without losing formatting irish2556 Reports 0 03-19-2009 04:51 AM
Exporting Data to Word and Formatting Tables Starman Modules & VBA 0 10-15-2008 10:42 AM
Preserve report format when exporting Kraj Reports 4 01-28-2004 07:25 AM




All times are GMT -8. The time now is 12:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World