currency formatting

[fishqqq]

Can someone suggest how i might get this line of code to read $50.20
instead of 50.2 ? (the field in question is [Sell Rate]

MessageText:="Please note the following invoice is overdue:" &
vbCr & "Invoice #: " & [REF #] & ": for the amount of " & [Sell Rate] &
" " & [Sell Rate Currency], _


Thanks, Steve

 

[Graham Mandeno]

Hi Steve

Use the Format function:

.... & Format( [Sell Rate], "Currency" ) & ...

or
.... & Format( [Sell Rate], "$#,##0.00" ) & ...

 

[fredg]

Can someone suggest how i might get this line of code to read $50.20
instead of 50.2 ? (the field in question is [Sell Rate]

MessageText:="Please note the following invoice is overdue:" &
vbCr & "Invoice #: " & [REF #] & ": for the amount of " & [Sell Rate] &
" " & [Sell Rate Currency], _

Thanks, Steve

amount of " & Format([Sell Rate],"$ #,###.00") & " " etc....

 

[fishqqq]

thanks worked perfectly