Send Email on Click Decimal Formatiing

[Lewis825]

I have a button which send an email, pulling data from a form. All works fine,

execpet one of the values is a caculated number.

The text box on the form rounds it to two decimal places so the value is correct on the form.

when I send it in the email, its not rounded.

......& "Unit Price:" & me.txtUnitPrice &.....

this is the section of the code running the email.

any ideas?

TIA

[ranman256]

"Unit Price:" & format(txtUnitPrice,"currency") &.....