visual basic5 version of instr()

[ninash]

Can anyone tell me how to trap say a space character in a string and return its position in the string using VB5.
I only ask as I have writen the code in vb6 using instr() for an access 2000 database and converted it access 97 and now it don't work
Does anyone know how it is done.....

 

[daimaou]

What exactly do you mean?
You are using Access 97 instead of Access 2000? Is that just it?

If so, Instr should work the same way.

InStr([start, ]string1, string2[, compare])

I'm currently using my app to work with Access 97 and Access 2000 and I don't get any problems.
What exactly is the error you are getting?

 

[ninash]

I found the error
Sorry it was a typo on my part but access 2000 excepted the error and performed the task where access 97 just locked up when it saw the error....

Sorry to have troubled you

 

[IronIke]

What was the typo? It sounds interesting the Acess 2000 would accept it and Access 97 would not.

 

[ninash]

I used the command instrrev() I don't know how it got there I was intending to use instr()
but the top command worked in 2000 but not in 97