[RESOLVED] Decimal format

Quick ?

assign 2 decimal placement to a label caption read from a recordset value

I tried using the Data Format field of the Label to set to 2o decimal places.

What is the Convert Function. I don't recall.

Thanks
Silly Me

Quote:

---

Originally Posted by Zoila

Quick ?

assign 2 decimal placement to a label caption read from a recordset value

I tried using the Data Format field of the Label to set to 2o decimal places.

What is the Convert Function. I don't recall.

Thanks
Silly Me

---

formatpercent() assigns 2 decimal places

Used

Format(Expression,"###,###,##0.00")

Thanks !!!!

the Formatpercentage give a % at the end.
Thanks !!!
:wave: