Simple, simple question: how do I display a number with two decimal places

[boflhusr]

It's been a looooong time since I used Access. I'm creating a new table.



In Access 2013, how does one display 12.34? I have a field called DividendYield. When I enter 10.99, I only get '10' in the field. The decimals get truncated.

The Data Type of the field is 'Number'.

In Field Properties (Design View), I already have my Field Size as 'Decimal' and my Format is 'Fixed'.

Thanks.

[mike60smart]

Hi

Change the Data Type to Currency and make the Format - Standard

[orange]

Remove Fixed from Format.
Try Decimals Auto.

[boflhusr]

Remove Fixed from Format.
Try Decimals Auto.

Thanks. Where do I find 'Decimals Auto'? I'm using Access 2013.

[boflhusr]

Hi

Change the Data Type to Currency and make the Format - Standard

The field is not Currency. The DivYield field is a percentage number ie. dividends paid/stock price. The result is manually entered from a web listing ie. it is not a calculated field. Thanks.

[June7]

Sounds like field was set as integer FieldSize

DecimalPlaces property has Auto.

If you always want 2 decimal places, including ending 0, need fixed Format.

Sounds like double FieldSize, fixed Format, 2 DecimalPlaces should work.

Aside from FieldSize, I seldom format fields in table. I format in textboxes.

[CarlettoFed]

If you attach an example file it is easier to see if there are errors and to help you.

[boflhusr]

@June7, I'm tempted to just make the field a 'text' data type, but I can't believe it can't be done. I've done it before -display a number like 12.34. I just don't remember how to do it. The reason I want it to have a number is because I want to calculate the average for the field eventually.

So what is your specific suggestion?

Did you include instructions how to attach a file in the forum? Why? Did my screen cap not work?

[boflhusr]

Sounds like field was set as integer FieldSize

DecimalPlaces property has Auto.

If you always want 2 decimal places, including ending 0, need fixed Format.

Sounds like double FieldSize, fixed Format, 2 DecimalPlaces should work.

Aside from FieldSize, I seldom format fields in table. I format in textboxes.

What should the Data Type be?

In the field's Field Properties dialog box what should I enter in as the Field Size and Format?

[June7]

Use Number DataType (I never use Currency).

I already said what you should use for field properties: Double FieldSize and Fixed Format and 2 DecimalPlaces.

[boflhusr]

I already said what you should use for field properties: Double FieldSize and Fixed Format and 2 DecimalPlaces.

It worked. Thank you!