Hello Board,

Again, thank you for all your help recently. I've learned a lot about Looping, Counting and Variables and have really put them to work several times over.

We use a database here with a field that contains a barcode number. It's 10 digits long.

Last night, i changed the field over from 'Number' to 'Text'; because we're about to start scanning alphanumeric codes into that field. It went OK and you can now input those alphanumeric codes into the field.

However, when i use our barcode reader to scan into that field, it puts a carriage return at the end of the number. This wasn't happening before.

Anyone know why? This can't be the way with all fields? Or is it text fields?

It's completely messed up the system, because the operator can't simply scan in barcode numbers.

The field is:

Text

Indexed

Unique

Maximum (10 Characters)

Message (Warning/Error!)

You can try to remove it with

Substitute ( text; "¶"; "" )

The bar code reader has always sent the carriage return. But Number fields don't allow them, so it's gotten stripped out. Now that you've got a text field you've got to handle the carriage return. Steve's Substitute() will work. Just put it in the "auto enter calculation" and make sure the field is set to not "Do not replace..."

WOW! Thank you, thank you!