Currency Format

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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"
 
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], "$#,###.")
 
Back
Top