Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Michael has attended:
Access Intermediate course

Access

How to have imperial units of measure instead of metric.

RE: Access - Metric units in Access

Dear Michael

Thank you for attending Access Intermediate!! I hope you enjoyed the course and benefited from it.


Please note that in MS Word you can change the metric to imperial by going to Tools > Options... and then in the general tab in the measurement units section.

Access doesn't have that option in the tools Options... dialog box.

If you want to achieve this result you have to follow these steps:

Go to Control Panel > Regional and Language > Customize button > In the Numbers Tab from the Measurement unit drop down list make the relevant choice.

NOTE: Please make sure that you restart Access after doing the above and you'll notice that you will be able to type the inches instead of cm.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 27 Jan 2009: Automatically marked as resolved.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.