Decimal places set to 1 but get 3

  • Thread starter Thread starter david
  • Start date Start date
D

david

I have a text box control with the property 'decimal
places' set to 1 but I get 3 decimal places printing.
What gives?
My control source is:
=([tothrs])/8
 
David,
One thing to check... in the Table design for this field/recordset, I
always remove any "default" formatting.
You didn't mention what you had entered for Format.
I would use this...
#.0; -#.0; .0; ""
Zeroes display as .0 and nulls display as "" (nothing).
Decimal places set to 1, as you say.
That "should" do it...
 
That gives me a decimal place even where there is not one
e.g. 25 comes out as 25.0, I definitely don't want that !!
-----Original Message-----
David,
One thing to check... in the Table design for this field/recordset, I
always remove any "default" formatting.
You didn't mention what you had entered for Format.
I would use this...
#.0; -#.0; .0; ""
Zeroes display as .0 and nulls display as "" (nothing).
Decimal places set to 1, as you say.
That "should" do it...

--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH


david said:
I have a text box control with the property 'decimal
places' set to 1 but I get 3 decimal places printing.
What gives?
My control source is:
=([tothrs])/8
Click to expand...


.
Click to expand...
 
So, you want your numbers displayed like:
25
32.2
3
41.2
4
etc?
If this is true, do you mind explaining why this type of format and not a
consistent number of decimal places? Just setting the decimal places value
isn't often enough. You must also set the format property to Standard.

--
Duane Hookom
MS Access MVP


David said:
That gives me a decimal place even where there is not one
e.g. 25 comes out as 25.0, I definitely don't want that !!
-----Original Message-----
David,
One thing to check... in the Table design for this field/recordset, I
always remove any "default" formatting.
You didn't mention what you had entered for Format.
I would use this...
#.0; -#.0; .0; ""
Zeroes display as .0 and nulls display as "" (nothing).
Decimal places set to 1, as you say.
That "should" do it...

--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH


david said:
I have a text box control with the property 'decimal
places' set to 1 but I get 3 decimal places printing.
What gives?
My control source is:
=([tothrs])/8
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top