A word Find can't find

[kupe]

A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.

I've tried it on another machine - also with Access2k - and it's the same.

Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.

 

[MarkK]

Check for trailing spaces, like "SZEE ", or control characters, like "SZEE" & chr(13)

 

[kupe]

Thanks, lagbolt. I tried that, I tried everything I could think of, including deleting the name and retyping it. Perhaps deleting the whole file and entering the data at the end of the db might be an answer.

But it seemed to be the combination of 'sze' - I suspected - that had the better of the program. Cheers

 

[kupe]

You must be right - but I don't know what it was. However, deleted and reinserted and Find obliges. Thanks very much, lagbolt.