I need to conver number (dollars) into text so I can inser...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a macro that will conver dollar amount (lets say $110) into
text so I can insert it as part of a text field (lets say "What you need to
pay is $110).
Can I do this? Can anyone help me with this? THANKS!!!
 
Don't understand why you need a Macro

Text = "What you need to pay is " & CStr(dollaramount)
 
Ofer,

I assume you mean you have a dollar amount in a field in your database?
Is this right? You would do this in a calculated field in a query or
a calculated control on your form or report. Let's say your field is
called Amount. So, in the Control Source of an unbound textbox on your
form, you would put...
="What you need to pay is $" & [Amount]
 
Steve,
YES!!! THANK YOU!!! YOU SAVED ME!!! THANKS A LOT

Steve Schapel said:
Ofer,

I assume you mean you have a dollar amount in a field in your database?
Is this right? You would do this in a calculated field in a query or
a calculated control on your form or report. Let's say your field is
called Amount. So, in the Control Source of an unbound textbox on your
form, you would put...
="What you need to pay is $" & [Amount]

--
Steve Schapel, Microsoft Access MVP

I need to create a macro that will conver dollar amount (lets say $110) into
text so I can insert it as part of a text field (lets say "What you need to
pay is $110).
Can I do this? Can anyone help me with this? THANKS!!!
Click to expand...
Click to expand...
 
Dennis,
Yes, sometimes its good to ask someone for help just to realize that you
were making things way too complicated. Thanks!!
 
Back
Top