Format Question

[Guest]

Simple method - in design view format the control as currency

HTH

 

[Bob V]

How do I get this text box to format $#,###.## at the moment I am getting
Grand Total:1085.5 instead of Grand Total $1,085.50
= "Grand Total:" & (NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID
=" & tbOwnerID.Value),""))
Thanks for any Help...............Bob

 

[Bob Quintal]

That does not work because of "Grand Total" in the code.....Thanks

the legend Grand Total belongs in a label to the left of the
textbox,.

If you insist in leaving it in the textbox, use the format()
function as follows

= "Grand Total: $" & Format((NZ(DLookUp
("Payable","qPayableTotalForPayment","OwnerID
=" & tbOwnerID.Value),"")),"#,###.##")

 

[Douglas J. Steele]

= "Grand Total:" &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID " &
tbOwnerID.Value),"")), "$#,###.00")

 

[Bob V]

That does not work because of "Grand Total" in the code.....Thanks Bob

 

[Bob V]

Thanks Doug, But its giving me an #Error, this is the original Code that
works!....Regards Bob
=(NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
tbOwnerID.Value),""))

 

[Bob V]

Thanks Bob Brilliant ......Regards Bob

the legend Grand Total belongs in a label to the left of the
textbox,.

If you insist in leaving it in the textbox, use the format()
function as follows

= "Grand Total: $" & Format((NZ(DLookUp
("Payable","qPayableTotalForPayment","OwnerID
=" & tbOwnerID.Value),"")),"#,###.##")