limit decimal places

[ardagh]

I have the following code to calculate output per hour. It works but how can I limit the result to two decimal places.


Private Sub Hours_AfterUpdate()

Me.lbloutputph.Caption = Me.Qty / Me.Hours
End Sub



Thanks

 

[PHV]

Me.lbloutputph.Caption = Format(Me.Qty / Me.Hours, "#.##)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lupins46]

Me.lbloutputph.Caption = format(Me.Qty / Me.Hours,"#.00")

 

[ardagh]

That works fine

Thank you