cm to inches

B

Bianca

Hello,

I was wondering if somewhere in the options of access there is a field where
I can change from centimetres to inches (word & excel both have this).

thanks!!
B
 
D

Douglas J. Steele

Access gets its units from whatever has been defined in Regional Settings.

That having been said, you can still work with inches, even if Access
defaults to centimetres. For example, you can type 1" as a property, and
Access will automatically convert it to 2.54 cm for you.
 
D

Douglas J. Steele

A shortcoming I delight in bringing to the attention of the Access
development team! <g>
 
T

Tom Lake

Klatuu said:
But it can't convert Furlongs Per Fortnight to Miles Per Hour.
Click to expand...

Hah! I bet you though you could fool us!

FUNCTION FPFToMPH (S)
FPFToMPH = S / 2688
END FUNCTION

Tom Lake
 
K

Klatuu

Tom wins the Irrelevant Genuis of the Day award.
I think there are only 3 people on the planet who know that.
 
K

Klatuu

Well, probably true these days, but in 1980 in a fit of boredom a friend of
mine and I decided to calculate it.
We even tried to build a speedometer that would display it, but the pointer
never moved. Must have been a technical problem :)
 
T

Tom Lake

Tom wins the Irrelevant Genuis of the Day award.
I think there are only 3 people on the planet who know that.
Click to expand...

Them's fightin' words, Clem! I may be irrelevant but I ain't no genius!

Uhhh, what's "irrelevant" mean?

8^)
 
K

Klatuu

It means you know a lot of stuff that has absolutely no value :)
Maybe we should call in Null Genius?
 
B

Bianca

Oh my!!! You guys having fun???

Where in the regional settings - all I can find there is date, currency etc
format! You mean just because I live in Europe it automatically grabs cm??
Like I said before - in word and excel in the options you can change it - how
come word and excel dont take from the regional settings.

I need to change it in access because I dont like the look of things when I
am setting up forms ect - any ideas??
 
B

Brendan Reynolds

Click the 'Customize' button on the 'Regional Options' tab in the 'Regional
and Language Options' dialog box. This will open a 'Customize Regional
Options' dialog box, where you'll find 'Measurement system' on the 'Numbers'
tab.

Details may vary somewhat between different versions of Windows and
depending on whether 'classic mode' is selected, etc.
 
B

Bianca

Thank you very much!!!

Brendan Reynolds said:
Click the 'Customize' button on the 'Regional Options' tab in the 'Regional
and Language Options' dialog box. This will open a 'Customize Regional
Options' dialog box, where you'll find 'Measurement system' on the 'Numbers'
tab.

Details may vary somewhat between different versions of Windows and
depending on whether 'classic mode' is selected, etc.
Click to expand...
 
Top