473,598 Members | 3,266 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 1983
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
1401
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
15820
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 object and save it to a Word document that I can access from Windows Explorer. An additional info...
7
1790
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 document in IIS or rename the page in the application the default documents page_load event does...
1
2783
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
4347
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 Microsoft.Office.Interop. But with Microsoft.Office.Interop I couldn't fiure out how to stream HTML...
7
2823
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
2265
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
9486
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 to letter sized. The reports worked fine in Access 97, but in 2007, he's getting the printer...
0
1244
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 me..
0
7987
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7899
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8392
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8050
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
8264
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6718
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
3897
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2412
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
1504
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.