Here is the scenario.
Access XP using VBA.
I have a text field. The text that I have in the field is m-1234.
I am running a >= seek.
My first seek is m and it returns m-1234.
My second seek is m- and it does not find it.
My third seek is m-12 and it does not find it.
My last seek is m-1234 and it finds it.
Why does it not find m-1234 when I am doing a >= seek and my text is m- or
m-12?
This works with an Access 97 database not with an Access XP database.
Anthony England - 31 Jan 2006 14:37 GMT
> Here is the scenario.
> Access XP using VBA.
[quoted text clipped - 10 lines]
>
> This works with an Access 97 database not with an Access XP database.
I think I got caught by this bug before:
http://support.microsoft.com/kb/271661/en-us