Formatting A Calculation in an Unbound Control

[Learn2010]

I have an unbound text box with the following control source:

="The scores below are based on the number of total evaluations (" & Sum([TitleIDCt]) & ")."

I set the formatting of the control to Standard. It reads:

The scores below are based on the number of total evaluations (1718).

I need the comma to show up so it reads like this:

The scores below are based on the number of total evaluations (1,718).

Can this be done?

Thank you.

 

[pr2-eugin]

Try Format function..

? [URL="http://www.techonthenet.com/access/functions/string/format.php"]Format[/URL](52123,"##,###")
52,123

 

[Learn2010]

How would I work that into my entire statement? I tried and couldn't get it to work.

 

[pr2-eugin]

What do you have after adding the Format? What does not work? Please be a bit elaborate.

 

[Learn2010]

This does not work.

="The scores below are based on the number of total evaluations (" & Format (Sum([TitleIDCt]), "#,###"& ")."

 

[Cronk]

Count the number of left and right brackets. You'll find one of the latter missing.

 

[pr2-eugin]

As Cronk has made it clear, the problem is concatenating the wrong bracket. Try.

= "The scores below are based on the number of total evaluations (" & Format(Sum([TitleIDCt]), "#,###"[COLOR=Red][B]) & ")." [/B][/COLOR]