Currency Value in a Text Object

[furlman41]

When I put a currency value in a text object with a string value, the currency value is displayed different than the rest of the values.

If it was a database currency object it would be displayed as:
$ 325.67

However, when I put the database currency object and a comment into a text object. Now, the text object doesn't have a space after the dollar sign:
$325.67 (estimated)

Any way to make this display with a space after the dollar sign so all my values are consistent?

John

 

[pgtek]

Hi
you can create a formula and use CDbl function to convert currency field to a number field in the formula editor as follows:

'$' + CStr(CDbl({currency_field}))

cheers

pgtek

 

[pgtek]

hi
i gave u the wrong answer
here the one

insert your field in the text box
after hit the space bar and then add (comment)
you should have a space inserted
if not
create formula

@Example
currency_field + " " + "(comment)"

this should work also

cheers

pgtek

 

[pgtek]

hi
or try this one
create formula

@Example
"$" + " " + right({currency_field},5) + " " + "(comment)"

this should work also

 

[furlman41]

pgtek-

Creating a formula didn't work, but the first response you gave to me did the job, although a little bit cumbersome.

'$' + CStr(CDbl({currency_field}))

Thanks.

Also, I couldn't use the formula with
"right({currency_field},5)"
because the currencies are not always 5 long.

John