Decimal places set to 1 but get 3

[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

 

[Al Campagna]

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

 

[David]

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

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

.

 

[Duane Hookom]

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

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

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

.