How to stop numbers from rounding?

[sondriven]

I am making a simple subform in a form and have a quantity and a unit price to figure a total cost.

I got the total cost to work easily with an expression, but for some reason the unit price field keeps wanting to round up or down automatically.

I dont remember setting anything for this. In the table it is set as a number/currency.

I thought I could change it to text but then I lose the dollar sign.

Thanks for any input you might have.

John

 

[The_Doc_Man]

Not sure you can stop it from rounding. Is there a format statement associated with the table or form field that asks for fewer decimal places than you intend to show? That's the first thing I would look for. (And I'd look at the currency field first, because I think there is a default number of decimal places even if you never set it to anything.)

 

[sondriven]

I got it. I had to switch the long integer to single.

Thanks.

John

 

[Birdy]

Thanks for this, I been having this problem on invoices for months and never been able to correct it even with complex formulas.

 

[rpadams]

Could be size of text box

Even when set to number type = single, you may get the APPEARANCE of rounding on the screen if the textbox showing the value is not wide enough. Interestingly, different screen resolutions can lead to different behavior on different computers. When I am trying to squeeze the max out of my screen real estate, it may work on my computer but not my clients. I always make my textboxes a little wider now than absolutely necessary for this reason.

 

[Raven]

Hey a big thanks from me too, I didn't have much time to check this one out for a colleagues, so I searched the forum and found yer post.

It worked first time, which is pretty amazin for me!

Thanks again.