Rounding Currency

M

Mike

Hello MVP's
Is there a way that I can round this formula that I have for a control source
of a textbox
txtSubTotal value = 3.15
Textbox1 ControlSource =Nz([txtSubTotal]*0.0675,0)
So instead of this $0.2126
I would get this $0.21
The Textbox that I have the formula in looks like $0.21 but I have a command
button that adds this the Textbox value to a subform which turns the 0.21 to
0.2126
 
B

boblarson

There is a ROUND function which allows you to specify to how many decimal
places you want to round.
 
Top