formatting

[kingsgambit]

I have a form where the user can choose from a combo box an item, the price is then shown in a text box, they then put in the qty, and a text box calculates the results but I can not format the result into currency this is the code I put in
Me.Total = Format(M1off * Qty, "currency")
Can anybody tell me what I am doing wrong

 

[Rich]

Set the controls format to currency in the property sheet.