Find records where linked record no longer matches...

[Mark53c]

Hi everyone, I want to use the barcode to find the exact record, but somehow it keeps listing relevant records.

My barcode formula is TX1, TX2...

But when I look up the barcode for TX2, it also shows TX20, TX220

Can it be fixed? 

Thanks in advance

[TheTimeSavingCo]

I don't think so I'm afraid as it doesn't search for identical matches.  Perhaps you could try to make your barcode formulas have leading 0s instead?

"TX" & 
REPT(
  '0', 
  4 - LEN(Number & "")
) &
Number