Make Variable 2 Decimal places

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

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

Thanks

Les
 
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.
 
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
 
Back
Top