Stop Rounding on Unbound Text Box

[LaurieW]

I have been searching thru these posts for help on rounding but haven't found an answer for my situation.

I have a Form with unbound text boxes whose calculations that are rounding. All of the text boxes are unbound and are NOT fields that come from a table, so I can not set their field type as I have read in other posts.

Here is what I have on my form:

#1 - unbound text box that counts checkboxes; this text box's format is set to General Number with zero decimal places.

#2 - unbound text box the user types an invoice amount into. This text box's format is set to Currency with 2 decimal places.

#3 - unbound text box that does the calculation of #1 divided by #2. This text box's format is set to Currency with 2 decimal places.

The calculation in #3 is always rounding and I don't understand why. If, for example, I have an amount of $300.99 and have 3 checkboxes checked (the calculation is $300.99/3), I get a calculation of $100.00 instead of $100.33. Why?? Can this be corrected somehow? I have tried many things to no avail. Hope someone can shed some light on this...thanks!

 

[CEH]

Heres a link that shows a bit about formatting using vba, this might help you.
http://msdn.microsoft.com/en-us/library/aa195902(office.11).aspx
You might also use something like Total = cdbl([FirstTextbox]) +cdbl([SecondTextbox])

Your probably formated as Long Integer when it needs to be single or double... check out Pats last comment on this post.
http://www.access-programmers.co.uk/forums/showthread.php?t=37314&highlight=stop+rounding

 

[missinglinq]

You're sure the calculation being done is

300.99/3

and not

300.99\3?

300.99/3 should yield 100.33

but

300.99\3 will yield 100.00

The backslash returns an Integer, as Curtis suggested.

 

[LaurieW]

Thank you! Yes, I did have a backslash (\) instead of a slash (/) in the calculated fields. I've changed it and it works now! Thanks again!

 

[missinglinq]

Glad to help!