entering top and left control positions in centimeters autocorrects

  • Thread starter Thread starter RAM
  • Start date Start date
R

RAM

After having searched and ... searched, I decided to try this group as
a last resort.

When I manually enter the values for TOP and LEFT of a control in
centimeters (european regional settings),
for example : 1.455 and 3.78
access 2003 changes this into 1.456 and 3.79
so I have to go back in and enter 1.454 and 3.77 which access then
changes into the desired 1.456 and 3.79

These are fictious numbers but the symptom isn't.
Why does he do that and how do I get access to accept the values as I
type them.
Note:it does not always have this behaviour. Only for certain values.

Thanks in advance!
Rudi.
 
Although ACCESS lets you type in numbers for the centimeter value, ACCESS
actually uses twips for the grid, not centimeters. So what is happening is
that the centimeter number you've entered does not equal a "round number" of
twips, so ACCESS adjusts the number so that it does.
 
Hi Ken,

thanks for the quick reply.

The strange thing is the following.

Suppose I need a command button to have a Left-value of 20.316 cm.
After I enter this Left-property-value, access changes this into
20.317 cm.

According to your explanation this behaviour indeed looks acceptable
to me.

However, I can manage to have access accept 20.316 by simply entering
20.315
Access then changes it into 20.316 himself. And 20.316 was the value I
wanted it to be at the start.

So this way it appears that it is an acceptable value. But why didn't
access accept it then in the first place
and why do I have to force access to accept it by entering a slightly
lower value?
Regards,
Rudi
 
The reason for that apparent discrepancy is because of how computers handle
floating point numbers; they're not exact when they're stored, so I'm
guessing that the value stored when you enter 20.316 is really something
like 20.3160000000003 or something like that. ACCESS rounds that up to
nearest 0.001 cm. When you enter 20.315, that may be 20.3150000000001, which
is rounded to 20.316.

If you find such behavior "interesting", try it with inches as the entered
value < grin >. You'll see it behave even stranger.
 
Thank you Ken for following up.
So I guess I'll have to get used to this.
Thanks again for your reply!

Regards from Belgium.
Rudi.
 
Back
Top