formatting data in a report

[Deborah]

My control source in a text box in my report reads like this:

="(April 1, 2003 - March 31, 2004): $" & [TotalContract]

How do I format the [TotalContract] field to two decimal places?

The field itself is formatted in the table that the report is based on. But whenever I add text to the control source, it removes all formatting for the field.

Your help is very appreciated.

 

[jfgambit]

try:

="(April 1, 2003 - March 31, 2004): " & Format([TotalContract],"Currency")

Note how I removed the $....

HTH

 

[Deborah]

You are SO AWESOME! Thanks

...um, sorry to bother you again but how can I make the field bold now...just the field part of the control, not the whole thing.

I really need to take some sort of VB course, don't I? Sigh. Thanks for your help.

 

[Deborah]

That's what I figured. But it didn't hurt to try

Thanks.

 

[nightwalker]

bold and decimal places

I believe the field type you need is FIXED and not currency for 2 decimal places ( unless i got u wrong and its a currency field on its own in table or using firlds which are currency)...
also you can make field value bold by clicking on menubar and then:
View--> Toolbars-->Formatting (Form/Report)
this would show toolbar and then you need to choose the textbox or label or any control you want as bold.
walker

That's what I figured. But it didn't hurt to try

Thanks.

 

[Deborah]

Thanks for the input but currency works perfectly for this case. Also it's just the field value that I wanted in bold, not the entire control.

Cheers,
Deborah