Currency Format

T

Tom

The user enters a price in a textbox, whose format property is Currency & no
decimal places, on a form. On the AfterUpdate event a msgbox comes up to get
the user to confirm the price. Within the string of that message is the
value of that textbox. How can I format this value to appear as currency but
with no decimal places.

TIA

Tom
 
M

Marshall Barton

Tom said:
The user enters a price in a textbox, whose format property is Currency & no
decimal places, on a form. On the AfterUpdate event a msgbox comes up to get
the user to confirm the price. Within the string of that message is the
value of that textbox. How can I format this value to appear as currency but
with no decimal places.
Click to expand...


Use the Format function:

"xxx" & Format(textbox, "$#,##0") & "yyy"
 
F

fredg

The user enters a price in a textbox, whose format property is Currency & no
decimal places, on a form. On the AfterUpdate event a msgbox comes up to get
the user to confirm the price. Within the string of that message is the
value of that textbox. How can I format this value to appear as currency but
with no decimal places.

TIA

Tom
Click to expand...

MsgBox "The amount was " & Format([ANumber], "$#,###.")
 
Top