decimal places in combined textbox

[geebee]

Hi,

I have a textbox [Status_for_programs] in my report which
has a control source like thhe following:

="The sum for the programs is " & [text141] & "." & "This
results in a balance of " & [text21] & " for all the
programs."

[Text141] and [Text21] have DSum functions as their
control source. I made sure that these two fields have a
format type of "Currency" and made sure the number of
decimal places is set to 2 for both fields. However, when
I combine these two fields along with words in the
[Status_for_prorgrams] field, I lose the dollar signs as
well as the number of decimal places (originally set to 2
in the two fields.

For example, although the result of [Text141] and [Text21]
may be $140,000.34 and $20,000.26 respectively, I get the
following result for the [STatus_for{programs]:

The sum for the programs is 140000.3363388889999. This
results in a balance of 20000.257823999 for all the
programs.

Does anyone know how I can keep the dollar signs and keep
the number of ecimal places to 2 (instead of 8) in the
[Status_for_programs] field?

Thanks in advance,
geebee