dealing with ' in combo's and filtering??

  • Thread starter Thread starter SUB
  • Start date Start date
S

SUB

Hi all,

does anyone know how to deal with the ' character?? I
find that if this character is in my data and I try using
a combo to filter data, it bails out because this
character is also the field seperator?? I know it can be
done because you can filter on the same data on the Access
toolbar and that does it fine??

thanks in advance

SUB
 
Hi all,

does anyone know how to deal with the ' character?? I
find that if this character is in my data and I try using
a combo to filter data, it bails out because this
character is also the field seperator?? I know it can be
done because you can filter on the same data on the Access
toolbar and that does it fine??

thanks in advance

SUB
Click to expand...

Your actual code would have been helpful here.
Instead of using
[SomeField] = '" & ComboName & "'"
use:
[SomeField] = " & chr(34) & ComboName & chr(34)
 
Superb, that did the trick..

my god this place is great..

..... 8O) ....

cheers again, SUB
-----Original Message-----
Hi all,

does anyone know how to deal with the ' character?? I
find that if this character is in my data and I try using
a combo to filter data, it bails out because this
character is also the field seperator?? I know it can be
done because you can filter on the same data on the Access
toolbar and that does it fine??

thanks in advance

SUB
Click to expand...

Your actual code would have been helpful here.
Instead of using
[SomeField] = '" & ComboName & "'"
use:
[SomeField] = " & chr(34) & ComboName & chr(34)

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top