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

access/courses - how do i format

Forum home » Delegate support and help forum » Microsoft Access Training and help » access/courses - How do I format numbers in tables to hold two decimal places?

access/courses - How do I format numbers in tables to hold two decimal places?

ResolvedVersion Standard

Christine has attended:
Access Introduction course
Access Intermediate course

How do I format numbers in tables to hold two decimal places?

I am trying to use a database that someone else has created and need to format one of the number fields to two decimal places.

RE: How do I format numbers in tables to hold two decimal places

Hi Christine,

Switch to design view, and click on the Data Type cell of the field you want to add decimal places to.

Look at the Field Properties below. Under the General tab, you can adjust the Decimal Places value (third property down). Type 2, or choose 2 from the drop-down box.

If this answers your question, please mark this question as resolved.

Hope you enjoy your Access Intermediate Course tomorrow.

Regards, Rich

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.1 secs.