I have a backend Sybase Central, Front End MS Access 2000
I had a table tblBadge, there is a field in the table named "BadgeNo" Char (6), not null, unique.
Badge No starts with "W", I am now at W99999 so I changed Char size to 7 and relinked the tables. When i search through the front end I no longer get the records.
I serach for W70000, no record
I add an extra 0 to the record W700000 and I get teh record.
It seems like now that I have added an extra value size to BadgeNo it is looking dfor an extra digit.