Replacing characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have read all the posts and tried all the suggestions, but still get -
list separator or ) is required - message

replace(rsOpenpo.Fields(4),""","inch")

rsOpenpo.Field(4) is a string that contains " character

Please help.

Thanks

P.S. I normally not that dumb, but todays isn't my day I guess
 
You know I figured out what I was doing wrong :) Duh!

I was trying to use this function with out really thinking, totally not my
day. I think I can get it to work now.
Public Function QS(AString As String) As String

'VBA.Strings.Replace() requires Access>=2000
QS = "'" & Replace(AString, "'", "''") & "'"

End Function

t
--
If at first you don''''''''t succeed, destroy all evidence that you tried.


David F Cox said:
'"' single quote double quote single quote worked for me
Click to expand...
 
Back
Top