cm to inches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
A shortcoming I delight in bringing to the attention of the Access
development team! <g>
 
Klatuu said:
But it can't convert Furlongs Per Fortnight to Miles Per Hour.

Hah! I bet you though you could fool us!

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

Tom Lake
 
Tom wins the Irrelevant Genuis of the Day award.
I think there are only 3 people on the planet who know that.
 
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 :)
 
Tom wins the Irrelevant Genuis of the Day award.
I think there are only 3 people on the planet who know that.

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

Uhhh, what's "irrelevant" mean?

8^)
 
It means you know a lot of stuff that has absolutely no value :)
Maybe we should call in Null Genius?
 
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??
 
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.
 
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.
 
Back
Top