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. :)

try:

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

Note how I removed the $....

HTH

You are SO AWESOME! Thanks :D

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

Bold is a property of the control. It cannot be applied to just part of the string being displayed. If you want the money part to be bold, put it in its own control.

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

Thanks.

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


Originally posted by Deborah
That's what I figured. But it didn't hurt to try ;)

Thanks.

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 :)