I bought a barcode font. The font needs an asterisk before and after the field. I have eight fields represented in barcode. All scan after printed except for one field, even though the data field is formatted identically ... "*" & [Table.Field] & "*" . The older records in the table format correctly and can be scanned ... it's only the new records that won't.
I noticed that the field that won't scan does not have a * at the end. After beating my head against the wall I decided I'd run an update query to put the * before and after the data (figuring I could resort to running it in a macro before the form opens if need be), but it only worked on older records in the table. I get a * at the beginning and end of all the older records, but the new ones only have a * at the beginning ... it its not putting a start at the end.
Does anyone have any idea why some records in the same table will NOT update? This is driving me batty!!! Thanks.