Formatting Text box

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

Guest

Hi all..

I have a text box that is setup to do a sum in a report:

=sum[(MoneyTotal]). But when it display's it looks like this: 1000.00 or
12000.00. How do I get it to have the "$" in front of it and put comma's in
IE $1,000.00 or $12,000.00.

Thanks
R~
 
If the text box has a Control Source, then I would consider it "bound" not
"unbound". Try set the Format property to Currency.
 
Ah crap........ Thanks when I looked at the list I didn't realize the format
had a scroll bar...........

Doh....

R~

Duane Hookom said:
If the text box has a Control Source, then I would consider it "bound" not
"unbound". Try set the Format property to Currency.
--
Duane Hookom
MS Access MVP

Rhett_Y said:
Hi all..

I have a text box that is setup to do a sum in a report:

=sum[(MoneyTotal]). But when it display's it looks like this: 1000.00 or
12000.00. How do I get it to have the "$" in front of it and put comma's
in
IE $1,000.00 or $12,000.00.

Thanks
R~
Click to expand...
Click to expand...
 
Back
Top