Formatting the return value 1

[pdbowling]

Hello all,
I have a Work Order number being pulled into a Crystal Report. It is placed into a Bar Code font field. I need the Work Order number to have an asterisk before and after it in order to be read by the hand scanner. How to I format the field so that it automatically includes the asterisks.

ex.
*1111111*

Thanks everyone
PB

 

[dgillz]

Is this a number field or a string field?

If this is a string field, just write a formula:

+"*"+{YourStringField}+"*"

If it is a number it is a little tougher:

+"*"+totext({YourNumberField},0,"&quot+"*"

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com