Changing from inches to centimeters

  • Thread starter Thread starter BudM
  • Start date Start date
B

BudM

I am trying to work in centimeters in MS Access, it is currently in inches.
I don't know where to make the change to centimeters.

Any help would be greatly appreciated.

thanks
Bud
 
Hi,
Do you mean the Ruler units?
If so, you have to change your regional settings in the control panel.
At least in A97 you do.
Go the control panel and open Regional Options and then on the Number
tab, select Metric from the Measurement System dropdown.
 
I guess I should have mentioned that I am running Access XP on a Win200
system. I already had set my regional options set to metric, but Access must
be ignoring that.

thanks very much for your help
Bud
 
BudM said:
I am trying to work in centimeters in MS Access, it is currently in inches.
I don't know where to make the change to centimeters.

Any help would be greatly appreciated.

thanks
Bud
Click to expand...

BudM,

If you're storing inches, just convert them to centimeters.

1 inch = 2.54 centimeters.

SELECT (M1.Width * 2.54) AS NewWidthInCentimeters
FROM MyMeasurements as M1


Sincerely,

Chris O.
 
I just tested in both Access 97 and Access 2003 (the two versions I have on
this machine), and changing the Regional Settings to Metric was all I had to
do. However, I did notice some peculiarities: I had to change it 2 or 3
times in Regional Settings before it stuck (I'd change it, Apply the change,
then go back in, and it would still be the old setting).
 
Back
Top