How many millimeters in creation mode versus page mode?

  • Thread starter Thread starter Telesphore
  • Start date Start date
T

Telesphore

If the left margin is 10 millimiters on page mode of a report, what would be
the number of millimeters in creation mode from the left side of the sheet
on 0 (zero)?

We need to fill up a government form (US Letter size).

Thank you.
 
Telesphore said:
If the left margin is 10 millimiters on page mode
of a report, what would be the number of millimeters
in creation mode from the left side of the sheet
on 0 (zero)?

I don't understand what you mean by "what would be the number of millimeters
in creation mode from the left side of the sheet on 0 (zero)?"

Number of millimeters to _what_? In the Properties of each Control on the
Report the position of its top measured from the top margin of the page, the
position of its left side measured from the left margin, and its width and
height. In design view (which I suspect is what you mean by 'creation
mode'), the units for those numbers are determined by your localization
settings -- that is, in the U.S. I would expect them to be in the
traditional English system (inches), but in France, I'd expect them to be
metric (millimeters).

The positions are actually stored in a unit called a "twip", which is 1/1440
th of an inch or .0006944 inches, so if you view or set them in VBA code,
that is the value you would use. If I use 25.4 mm / inch as a conversion
factor, a twip would be .0176 mm.

Larry Linson
Microsoft Office Access MVP
 
I'll give an example.

Measuring the official government form, we have to put one of the control
boxes at 15 mm left and at 27 mm from the top.

Then what would be the equivalent of those measures in design mode, taking
into account that the design mode starts at 0 mm and that the margins in
page mode are set by default at 25,55 mm left and 25,45 mm from the top?

Thank you.
 
Telesphore,

Perhpas this will help?

15 millimeter = 0.590 551 181 1 inch

27 millimeter = 1.062 992 126 inch

For further conversions try... http://www.onlineconversion.com/

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
I'll give an example.

Measuring the official government form, we have to put one of the control
boxes at 15 mm left and at 27 mm from the top.

Then what would be the equivalent of those measures in design mode, taking
into account that the design mode starts at 0 mm and that the margins in
page mode are set by default at 25,55 mm left and 25,45 mm from the top?

Thank you.
 
Thank you, this will surely helps, but our problem is mostly with the
coordination between the "sides" and the "margins" of the form, so that we
can fill it exactly where the government wants it.
 
Telesphore,

Not sure what anyone else here can do... This might be a *hold the two
papers up to the light* kinda thing (You government form and the Access
repport). I once had that, what a pain. The problem, as Larry said, it is
actually twips, so you need to do the conversion.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Thank you, this will surely helps, but our problem is mostly with the
coordination between the "sides" and the "margins" of the form, so that we
can fill it exactly where the government wants it.
 
Given your example you can't.

25.55 mm left margin is already greater than 15 mm. Your margins have to be
less than the position you want to put the control in on the printed page. So
you need to decrease the left margin to 15 mm or less - that may not be
possible with most printers.

The top margin is 27 mm and the top margin is 25.45 mm, so you would need to
position the control's top at 27-25.45 =1.55 mm ( or converted that is 0.0069").

If you express the measurements in centimeters instead of millimeters Access
will do the conversion for you if your version is using inches. Unfortunately
the page set up dialog won't do that for margins unless you change your
operating system settings to metric. (You can do that and then switch back to
"english" measurements.)

Good luck

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Telesphore said:
I'll give an example.

Measuring the official government form, we have
to put one of the control boxes at 15 mm left and
at 27 mm from the top.

Then what would be the equivalent of those measures
in design mode, taking into account that the design
mode starts at 0 mm and that the margins in page mode
are set by default at 25,55 mm left and 25,45 mm
from the top?

Design view of the Report shows the printable area (that is, only area
inside the margins), so you just add the allowance for the margin. If you
have specified (with PageSetup) a top margin of 25mm and a left margin of
35mm, then a Text Box in the Report with Top of 0 mm and Left of 0 mm will
print starting 25 mm from the top edge of the page and 35 mm from the left
edge of the page; a text box with a top of 100 mm and left of 25 mm would
begin 125mm from the top edge of the page and 60 mm from the left edge of
the page.

As John Spencer noted, if you have a left margin of 25,55 mm, you cannot
print at 15 mm from the edge of the paper. Thus, you should use File | Page
setup and specify the margins to be other than the default. (I usually
change the default margins on my reports.) Access will coordinate with the
printer driver to determine the physical minimum and will inform you if you
attempt to make the printer do something of which it is incapable.

Also, as Gina noted, it will sometimes be necessary to hold up the Report
output of trial data on plain paper with the actual form behind it in front
of a light, or a light board if you have one available, and make a few
manual adjustments.

In my experience, Windows / Access measurements are much closer to reality
for Reports than they are for Forms. If you carefully measure, and design a
Form based on those measurements, you may find that what is displayed, if
you measure on-screen, is not very close.

Larry Linson
Microsoft Office Access MVP
 
Thank you Larry,

You confirmed what I had alreaddy thought.
I put the top and left margins at 0. But the results are different according
to different printers, for example in mine the left was 4,23 mm and with the
one of the secretary it was 6,35 mm. And the printing had to be set with the
secretary.
 
Back
Top