I have the following formula which creates a barcode from a string and a numeric input field.

 

'*'& 'Q' & {?prfQuantity9} & '*'

 

I have changed the numeric format in  Report -> Options... so that the thousand separator is not displayed.  However, the numeric field in the formula is still picking up the ',' thousand separator which creates an erroneous barcode.

 

How do I format the numeric field within the formula to suppress the thousand separator?

 

Regards

CM

 

Cstr did the trick.  A slight tweak on the syntax to what you sent:

 

'*'& 'Q' & Cstr({?prfQuantity9},0) & '*'

 

Thanks for your help, much appreciated.

 

CM