Best way to report barcodes of text fields using CR XI

[GCL2007]

Hello, I have an odd situation. Using Crystal Reports XI, my user wanted me to dump our Customer Master into Excel with the Customer Name and a barcode. This is to be used for data entry into some other system. In trying to get the barcode, I used this formula BarcodeC39({CUSTOMER.COMPANY}) . All looks fine but testing the barcode, it is not handling characters like & correctly. For example BOB & JOHN CORPORATION would scan as BOB /F JOHN CORPORATION. Not sure if other funny characters would behave this away also. Any thoughts on how to handle? Thanks

 

[Charliy]

The 3 of 9 barcoding system does not contain an ampersand.

You can go thru your string and change it to "AND" or + before encoding.