problem with Instr function

[teel73]

I have the following value in 1 field: Latoria V
This value clearly has a space. When I use the Instr function to return the position of the space, it returns 0 and it returns 0 for all of the records. The field has a first name, space, then middle initial. Why is this? This is th function I have:

Instr(1,[FName],chr(32))

That returns 0. What am I doing wrong?

 

[pbaldy]

Have you tried

Instr(1,[FName]," ")

 

[teel73]

Yes, I tried that too. I don't know what is wrong.

 

[WayneRyan]

teel,

Can you paste the whole line of code?

Wayne

 

[Brianwarnock]

I think we may need to examine the DB.

Brian