Always display one decimal in a textbox

randommetalguy

Registered User.
Local time
Today, 03:49
Joined
Nov 25, 2008
Messages
52
I have a formulas that adds some numbers together. If I'm doing 5.5 + 5.5 I want to get 11.0. However, Access keeps saying it's just 11.

How can I get it to show the zero after the decimal place?

I've tried Fixed, 1 decimal and formatting to 0.0, 0.0, 0.0, etc but nothing is working.

Thanks in advance.
 
Set Data type to Number.
Field Size to Decimal
Format to 0.0
Decimal Places to 1
 
Set Data type to Number.
Field Size to Decimal
Format to 0.0
Decimal Places to 1

This is just a text box on my form. I am using VBA code to do the formula so there are no tables involved. I have already set Format to 0.0 and Decimal Places to 1 but 22 does not show up as 22.0. Datatype and Field Size are things I can customize with data in a database table.
 
In that case format should be either "Fixed" or "Standard"
 

Users who are viewing this thread

Back
Top Bottom