Form Letter

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

Guest

I have a question requarding a form letter that I am creating for one of my
customers. It is a gratitude letter thanking a particular person on a
donation that they have made. The problem I am experienceing is the amount
that is being refereced will not display as a dollar value with two decimal
places. How can I format the number with the text to display it as a dollar
amount with two decimal places. I provided the text box below.

=(" With gratitude, we thank you for your generous donation of " &
[Forms]![GratitudeLetter1]![Amount] & " for our " &
[Forms]![GratitudeLetter1]![Description] & ". " & "Little Flower Manor did
not provide any goods or services in consideration of this gift in the amount
of " & [Forms]![GratitudeLetter1]![Amount]) & "."
 
Use the Format() function:

=(" With gratitude, we thank you for your generous donation of " &
Format([Forms]![GratitudeLetter1]![Amount], "Currency") & " for our "
 
Allen,

Your suggestion worked. Thank You

Tom B.


Allen Browne said:
Use the Format() function:

=(" With gratitude, we thank you for your generous donation of " &
Format([Forms]![GratitudeLetter1]![Amount], "Currency") & " for our "

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

tomb said:
I have a question requarding a form letter that I am creating for one of my
customers. It is a gratitude letter thanking a particular person on a
donation that they have made. The problem I am experienceing is the amount
that is being refereced will not display as a dollar value with two
decimal
places. How can I format the number with the text to display it as a
dollar
amount with two decimal places. I provided the text box below.

=(" With gratitude, we thank you for your generous donation of " &
[Forms]![GratitudeLetter1]![Amount] & " for our " &
[Forms]![GratitudeLetter1]![Description] & ". " & "Little Flower Manor did
not provide any goods or services in consideration of this gift in the
amount
of " & [Forms]![GratitudeLetter1]![Amount]) & "."
Click to expand...
Click to expand...
 
Back
Top