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

[Ofer]

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!!!

 

[Dennis]

Don't understand why you need a Macro

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

 

[Steve Schapel]

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]

 

[Ofer]

Steve,
YES!!! THANK YOU!!! YOU SAVED ME!!! THANKS A LOT

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!!!

 

[Ofer]

Dennis,
Yes, sometimes its good to ask someone for help just to realize that you
were making things way too complicated. Thanks!!