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], "$#,###.")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test number of decimal places in Currency format 1
Displaying Currency 3
Currency and the number of decimal places 3
Zero Isn't Zero 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Formating # of decimal places displayed in Textbox 1
Enable user to change currency format 1
Currency format with 2 decimals not showing on report 2

Top