Adding a dollar sign before text.

[davidg47]

Does anyone know how to add a dollar sign ($) before the numbers in a text box on a report short of adding a lable? If the numbers are only 3 characters long, but the box is large enough to accept up to 7 figures from the database, then the dollar sign would be stuck out there in left field and look out of place. So, I want to try to avoid that.

Thanks

 

[matt330]

in the control source of a text box type ="$" & [fieldname]

 

[davidg47]

I tried the above formula, but all I got throughout the report in that particular field is "#Error"

Any other ideas?

 

[Smart]

You could place the field containing the Dollar sign up against the field with the numbers. right align the dollar sign field then left align your number field and they will appear to be right next to each other

 

[matt330]

In the control source of the existing field on the report you have [FieldName]. I have a feeling your just adding " = "$" & " prior to the field name. This is what results in the error.

Set the properties of that field to "not visible", place an unbound text box over directly over it, and then type in the control source of that text box = "$" & [FieldName] That should do the trick.