How do I display currency in a text string like: "Guaranteed paym.

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

Guest

I set the field to "currency", but when I string text and the field together
- it won't show the dollar amount. For example,

where the value for [benefitamount] is $1,000

In the Ab| box I wrote: ="Guaranteed Lump Sum of"&[benefitamount]

It shows up in the report as: Guaranteed Lump Sum of 1000

I want it to read: Guaranteed Lump Sum of $1,000

Thanks for your help.

John
 
jmuirman said:
I set the field to "currency", but when I string text and the field together
- it won't show the dollar amount. For example,

where the value for [benefitamount] is $1,000

In the Ab| box I wrote: ="Guaranteed Lump Sum of"&[benefitamount]

It shows up in the report as: Guaranteed Lump Sum of 1000

I want it to read: Guaranteed Lump Sum of $1,000
Click to expand...


Once you concatenate the two items, the result is a string
and no numeric format can be applied to a string of
nun-numeric characters.

To do what you want, use the Format function (instead of the
text box's Format property:

="Guaranteed Lump Sum of"&Format([benefitamount],"Currency")
 
It works! Much Thanks!

John

Duane Hookom said:
Try:
="Guaranteed Lump Sum of "& Format([benefitamount],"Currency")


--
Duane Hookom
MS Access MVP


jmuirman said:
I set the field to "currency", but when I string text and the field
together
- it won't show the dollar amount. For example,

where the value for [benefitamount] is $1,000

In the Ab| box I wrote: ="Guaranteed Lump Sum of"&[benefitamount]

It shows up in the report as: Guaranteed Lump Sum of 1000

I want it to read: Guaranteed Lump Sum of $1,000

Thanks for your help.

John
Click to expand...
Click to expand...
 
This is great - much Thanks!

John


Marshall Barton said:
jmuirman said:
I set the field to "currency", but when I string text and the field together
- it won't show the dollar amount. For example,

where the value for [benefitamount] is $1,000

In the Ab| box I wrote: ="Guaranteed Lump Sum of"&[benefitamount]

It shows up in the report as: Guaranteed Lump Sum of 1000

I want it to read: Guaranteed Lump Sum of $1,000
Click to expand...


Once you concatenate the two items, the result is a string
and no numeric format can be applied to a string of
nun-numeric characters.

To do what you want, use the Format function (instead of the
text box's Format property:

="Guaranteed Lump Sum of"&Format([benefitamount],"Currency")
Click to expand...
 
Back
Top