Print Preview opens in less than 50% - Microsoft Access / VBA

232 100+

This code opens Print Preview in less than 50% which is not easy to read

Expand|Select|Wrap|Line Numbers

 DoCmd.OpenReport "rptCm", acViewPreview, , "C_NO like '*" & TXTCNO & "*'"
 

kindly help to open it in 100% view by default.

Nov 19 '12 #1

Subscribe Post Reply

1562

TheSmileyCoder

2,322

Expert Mod 2GB

I am working in Access 2010 now, which works slightly different when it comes to report design, so I can't test this currently

Try setting the AutoResize and FitToPage to True.

Nov 19 '12 #2

ADezii

8,834

Expert 8TB

Wouold not a MAXIMIZE Command in the Open() Event of the report do the trick?

Expand|Select|Wrap|Line Numbers

 Private Sub Report_Open(Cancel As Integer)

  DoCmd.Maximize

End Sub

Nov 19 '12 #3

zmbd

5,501

Expert Mod 4TB

Make it easy... nothing to add to the report unless you open in dialog mode:

right from the MS website:

Expand|Select|Wrap|Line Numbers

  DoCmd.OpenReport stDocName, acPreview

    DoCmd.Maximize

    DoCmd.RunCommand acCmdZoom150

Of course stDocName is a string etc...
acCmdZoom150 sizes an 8-1/2" x 11" page so that the widith is visible across my LCD and about a 1/3 of the top page; however, I have a very nice large monitor that has the nifty rotate that allows me to turn the monitor longwise and see the entire page... :) so you may need to use acCmdZoom100 or acCmdZoom75

Nov 19 '12 #4

Similar topics

BST: remove less than

by: Ridimz | last post by:

I have implemented a binary search tree and am interested in displaying all keys less than a certain value. I understand how to approach this task if the searchValue is equal to root.key()....

C / C++

different asp.net server tags (less than Percentage symbol hash or equals)

by: fake ID | last post by:

Since you can't search for these symbols used in asp.net "<%#" or '<%=' I thought i'd post this to make things a little easier to find. Potential search word combinations: -lessthan Percentage...

ASP.NET

using less<string>...

by: Martin Jørgensen | last post by:

Hi, - - - - - - - - - - - - - - - #include <iostream> #include <string> #include <map> using namespace std; int main() {

C / C++

Python less error-prone than Java

by: Christoph Zwerschke | last post by:

You will often hear that for reasons of fault minimization, you should use a programming language with strict typing: http://turing.une.edu.au/~comp284/Lectures/Lecture_18/lecture/node1.html I...

Python

Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End

by: Greg Strong | last post by:

Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...

Microsoft Access / VBA

How does std::set stay unique with only std::less?

by: Cory Nelson | last post by:

Does anyone know how std::set prevents duplicates using only std::less? I've tried looking through a couple of the STL implementations and their code is pretty unreadable (to allow for different...

C / C++

Problems with std::less

by: ek | last post by:

I have the following class: template<typename I> class test { public: test(I i) : pp(i) {} I getpp() const { return pp; }

C / C++

Error when using std::less

by: desktop | last post by:

I get this error when I run my program: red_black_tree.cpp:188: error: no matching function for call to ‘std::less<MyObj<int::less(MyObj<int>&, MyObj<int>&)’...

C / C++

Perl output redirection and gnu less problem

by: gnidoc | last post by:

This is a small perl script I wrote to check mirror lists (files filled with one URL per line). It prints " http://..." when an URL can't be retrieved and just prints the url when everything goes...

Perl

SQL Less Than returns wrong results

by: ukfusion | last post by:

I have an sql query which has several fields and no matter how hard i try i cant get the less than statement to work....i originally tried between but that wouldnt work either. $yourpricesearch is...

MySQL Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing