How do I change from millimeters to inches in Access?

[Guest]

I work in inches rather than millimeters to produce forms & reports for
printing purposes, but I can't find where to change to inches in either Excel
or Access 2000. It's easy to find in Word - but in Access & Excel I've
looked everywhere I can think but can't find it......can anyone help?

 

[Douglas J. Steele]

AFAIK, Access and Excel both get it from the Regional Settings. You have to
go through the Control Panel (and it'll impact all other applications on
your computer)

 

[Allen Browne]

Access does not have its own setting.

It uses whatever you specify in the Windows Control Panel, under Regional
Settings.

 

[Fred Boer]

Dear MoxieMorgan:

I believe that Access picks up these settings from the Regional Options in
the Windows Control Panel. Go to Regional Options>Numbers>Measurement...

HTH
Fred Boer

 

[Chuck]

On Sun, 14 May 2006 07:16:01 -0700, MoxieMorgan

Add a calculated field in your queries MM: [{field with inches}]*2.54

Chuck--