Make Variable 2 Decimal places

[Les]

I am trying to output a currency variable to 2 decimal places is there a
format for this?.

Thanks

Les

 

[Jeff Boyce]

Les

You didn't indicate if the underlying field was of type currency, or if you
are describing a form (or a query). There's a CCur() function (change to
currency) you can use in a query, and there's formatting you can do, both in
queries and forms. Take a look at the properties of the specific
field/control.

 

[Les]

Sorry Jeff

What I am doing is

Set SalesCalc = CurrentDb.OpenRecordset("tblSales_Calculation") 'table
Name

Salestot = SalesCalc!curSales_Total 'This is a currency field.

I am then sending this to the message part of an email and im getting 4
decimal places.

It's set to currency 2 decimal places in the table?

Les