Formatting Text box

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

 

[Guest]

Sorry I forgot to mention it is an unbound text box and I am using Access 2003.

R~

 

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

 

[Guest]

Ah crap........ Thanks when I looked at the list I didn't realize the format
had a scroll bar...........

Doh....

R~

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

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~