473,516 Members | 3,327 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do i change the page setup default on a document imported from access to word?

I'm trying to export an MS Access 2000 report to an .rtf file. In Access, default settings show page setup as letter sized. In word, my default settings show letter sized. However, when i export the document, it changes the page setup to a custom size of 17"x22". There are tons of reports so I don't want to have to change the print setup on each one before sending them out.
Nov 25 '10 #1
1 1977
MMcCarthy
14,534 Recognized Expert Moderator MVP
Firstly an rtf will not hold any formatting.

You could try using office automation to change the page size after it's been saved as an rtf.

Without knowing a lot more about your setup all I can give you is the basic code.
Expand|Select|Wrap|Line Numbers
  1. Documents("YourDocument").PageSetup.PaperSize = wdPaperLetter
Nov 27 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
556
by: Ira S | last post by:
I use a DYMO labelwriter with my Access 97 database. I just purchased a new computer and in the report section under page setup/paper size, the new computer keeps changing the size automatically. I know something must be different on the machines. But what? I have checked everything ! Thanks, Ira
2
1395
by: David Holmes | last post by:
Hi All I would ideally like to set the page setup values for my reports and have Access remember them in a run-time enviroment, but this doesn't seem to be possible. So how can I set the page setup variables using VB before opening the report ? I am mainly interested in setting the margins. Thanks in advance Dave
4
15805
by: Otis Hunter | last post by:
I have been given an Access Database which contains a table that has an OLE object field that contains a Word document. That table contains hundreds of records. I would like to find out how I can write a VB script, to be executed either within Access or executed at the CMD prompt, which will loop through all the records and open the document...
7
1786
by: aDc | last post by:
Hello, I am getting some strange behavior with my ASP.NET application. Anytime I make a request to a page in the application the page_load for that page is fired as expected BUT then the page_load for the default document configured in IIS (5.0) (in my case Default.aspx) fires also. This happens on every request. If I remove the default...
1
2775
by: gan | last post by:
I created a ASP.NET web setup project with the project name "Setup". I noticed that this name will be used as the default Virtual Directory name during deployment. I'd like to know whether we can change this default value while preserving the project name? Thanks in advance
1
4342
by: Andrew | last post by:
I'm adding this as it to me a while to figure out all the pieces to be able to do this without using Microsoft.Office.Interop which caused me problems on the web-server. Streaming is the easy part, but I couldn't initially work out how to manipulate the page setup to change page margins and orientation, that's why I was looking at...
7
2820
by: John | last post by:
Hi How can I change the printer page layout to landscape via code? Basically I would like to avoid having the user set the layout every time manually. Thanks Regards
2
2262
by: hstierho | last post by:
Using latest version of Access, XP Pro O/S. Using HP 4100 printer. When I choose legal and tray 2, the setting changes back to letter. I have three forms to print. The first form maintains the setting and prints legal size. The other two forms will not maintain the setting. Am i nuts?
4
9478
by: ARC | last post by:
I have reports that are designed to where it doesn't matter if the region using the program uses a letter sized paper or A4 sized. I have the width to be just slightly over 7", so the reports work with either paper size. However, in Access 2007, one of my testers in Australia is now getting a beep from his printer telling him to change paper...
0
1236
by: Drupan c | last post by:
hello everybody, i m new to vc# , i want an application where i can select multiple word files using File Dialog and change the page setup property of all the word files at once rather then changing it for each and every file manually.. is this possible using Microsoft.Office.Interop.Word namespace ?? plz guide...
0
7182
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7581
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7142
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7548
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5110
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3267
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
1624
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
825
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
488
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.