Formatting Text box

R

Rhett_Y

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~
 
D

Duane Hookom

If the text box has a Control Source, then I would consider it "bound" not
"unbound". Try set the Format property to Currency.
 
R

Rhett_Y

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...
 
Top