Exact Width and Heigh Measurements

[Super Steve]

I'm using Access 2000 and have found that I can't seem to set the
width and height of my reports to exactly what I want.

I'm creating a label report and the labels are 85mm x 85mm. However
if I enter "8.5cm" in the Width property then Access changes it
automatically to "8.501cm". If I enter "85mm" then I get an error
saying "The number is too large".

I did some experimenting and "8.4cm" is accepted ok, but "8.3cm" gets
changed to "8.392cm".

I tried turning off "Snap to Grid" but this made no difference.

Why is Access changing my measurements?

 

[Allen Browne]

Internally, Access stores these numbers as twips, where 1440 twips = one
inch.

Centimeters (and even thousands of an inch) are not exact multiples of
1/1440 inch, so the number you type is typically displayed slightly
differently after it is converted to twips.

Although I live in a country that uses cm, I ended up setting my
measurements to imperial (inches) in the Windows Control Panel (Regional
Settings), as I found it better for cases like you describe (labels where
the size is multipled several times over a page.)

Sometimes you can get a result closer to what you want if you actually
assign the value in twips. For example, if you open the report in design
view, open the Immediate Window, and enter something like this:
Reports![Report1]![Address].Width = 4705

 

[Super Steve]

Thanks, Allen, that explains why I'm having my problems. I'll try
your suggestion out.

Internally, Access stores these numbers as twips, where 1440 twips = one
inch.

Centimeters (and even thousands of an inch) are not exact multiples of
1/1440 inch, so the number you type is typically displayed slightly
differently after it is converted to twips.

Although I live in a country that uses cm, I ended up setting my
measurements to imperial (inches) in the Windows Control Panel (Regional
Settings), as I found it better for cases like you describe (labels where
the size is multipled several times over a page.)

Sometimes you can get a result closer to what you want if you actually
assign the value in twips. For example, if you open the report in design
view, open the Immediate Window, and enter something like this:
Reports![Report1]![Address].Width = 4705

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

I'm using Access 2000 and have found that I can't seem to set the
width and height of my reports to exactly what I want.

I'm creating a label report and the labels are 85mm x 85mm. However
if I enter "8.5cm" in the Width property then Access changes it
automatically to "8.501cm". If I enter "85mm" then I get an error
saying "The number is too large".

I did some experimenting and "8.4cm" is accepted ok, but "8.3cm" gets
changed to "8.392cm".

I tried turning off "Snap to Grid" but this made no difference.

Why is Access changing my measurements?