473,657 Members | 2,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Print margins not being honored in reports

3 New Member
This database has existed for years. In the past the reports always had 0.25" margins. Recently our president asked for some changes that required 0.00" margins on multiple reports. The full report width was changed to 8.5" to print on letter, and the margins were reduced to 0. All report pages are generated as PDF with "acOutputReport ,"",acFormatPDF ". This works fine on my computer with the ACCDB or ACCDE file. The database is split frontend and backend. All user have their own frontend (that is copied from the ACCDE file on the server (which is the ACCDE file that works fine for me). When another user prints a report they get the warning that the page width is wider than the page (blah, blah, blah). Any idea why the width/margin is not setup correctly for the co-worker?
Mar 8 '17 #1
2 1482
jforbes
1,107 Recognized Expert Top Contributor
I haven't spent to much time on this subject, but from what I've seen, Access will save the name of the last printer that the Report was formatted for during Design time. When the Report is Previewed, it will see if the Current Default Printer is the same as the Printer that was saved with the Report. When they don't match, Access will reset certain things to match the Default printer, as best as it can, like the Margins.

You might try adding this to the Report's OnOpen Event, I haven't tried it... It might work:
Expand|Select|Wrap|Line Numbers
  1. Me.Printer.TopMargin = 0
  2. Me.Printer.BottomMargin = 0
  3. Me.Printer.LeftMargin = 0
  4. Me.Printer.RightMargin = 0
Mar 8 '17 #2
crayhouse
3 New Member
I tried this approach, and it did not work for me. I did determine that it was the setting for the default printer. I set the "Default Printer" in page setup for the report. When I print the report on my computer, my default printer is a PDF printer (I rarely create a piece of paper). The co-workers print to paper daily, and have their default printers set to actual printers. Their actual printer does not have the capability of using a margin of "0" for any of the margins, so it sets the physical margin at the minimum for the printer...even though the report is create with acFormatPDF.

Unfortunately if I select a printer that the user does not have access to then that causes problems of its own. I do wish that Access could understand that acFormatPDF did not require a printer, and could ignore which printer to look at to determine if the settings would produce a useful report.
Mar 8 '17 #3

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

Similar topics

4
2280
by: Wendy Elizabeth | last post by:
I would like to know how to print a crystal report that was generated in the ..NET framework using a Visual Basic.NET web application and/or a Visual basic.NET windows application. When crystal reports runs by itself, you can do a print preview to see what the report will look like. I would like to know how to do this using crystal reports that is embedded in the Visual Studio.net 1.1 professional and enterprise architect versions. ...
2
2611
by: Greg | last post by:
I have 2 reports that are almost the same one is for internal use and the other is for the customer. The Internal report has a few extra fields then the customer report. The customer report has a criteria that the Internal report does not have so the customer will not see all the notes added for a job. Both reports the user has to put the customer code in for the report. How can I get this so that when they want both reports they just...
0
1771
by: John Dalberg | last post by:
I need to set IE's print left margin to a value smaller than the default 0.75 programmaticallly. I did some research and found some info about print templates on MSDN. However the info is too detailed and low level for my understanding. I also found an ActiveX product that costs $350/year. Any ideas or sample code on how to set the margins when a user prints in IE?
1
1179
by: bafidi | last post by:
i want links to read where it teachs me to print without cristal reports please help
1
2830
by: scrawnyguns | last post by:
There's probably something easy I'm missing here. When I run a print operation in my program (Microsoft VB.Net Form) I have some code that sets the print margins so that it leaves a nice gap, however, these gaps do not work. No matter what I set the margins to, the printer (HP Color Laserjet) always prints the same (top left corner with about a 5mm gap). Please Help.
7
20701
by: Mark | last post by:
Hi, I am creating application in VB 2005. and when I print report it adds extra 0.45 cm margin on left and top, and the reason for this is physical margins of printer. Is it possible to change printer's physical margins using VB coding? Cheers -- Osmotion Blue
1
2296
by: mehdi | last post by:
Hi folks, 1. Is there any equivalent to the "DocumentProperties" Win32 API in C#? 2. How am I supposed to retrieve the user-selected margins from a given Printer Properties dialog? (I got a printer installed that supports "Print Margins", however, I've got no idea how to retrieve that).
1
2310
by: Mango | last post by:
I'm trying to print some text in a very specific position on a page, so that it will show through the window of an envelope when folded. This is easy to do, as long as the browser's print margins are set to 0, or I subtract the width of the margins from the position of the text. My question is: is there a technique for detecting browser print margins? It'd be nice not to have to warn users to set them to something specific.
0
1444
by: Jason7899 | last post by:
hi, i use the crystal report for creat reports and print all that i want in vb or vb.net now i looking for a such like crystal report for use in php or html all data is retrieve from a mysql database. i have found something like crystal report working in java not javascript. but i unable to remember the name i know that tool is a free tool, anyway any one know something like that for creat and print reports? thanks a lot for your help...
1
1360
by: sarika81286 | last post by:
how to disable print option of reports in jsp/java servlet program . if any body have any idea please help...
0
8305
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
8823
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...
0
8730
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
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
7321
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
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4151
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...
0
4301
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
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

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.