How do I display/format currency in a text box in a report?
The report shows:
(3) Please forward a check to Rose Smith in the amount of 14721, but want to show $14,721.00.
so far I have:
="(3) Please forward a check to " & [claimantfirst] & " " & [claimantlast]&" in the amount of [seed money]
so i want to format [seed money].
examples are appreciated, but i also want to learn how to format fields witinin a text box.
Thanks,
John