Problem with character ' in openreport link criteria

[ciclismoenruta]

Hi,
In my code I have the following:

stLinkCriteria = "[nomcli] like '*" & Me![nomcli] & "*' "

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

If [nomcli] contains character ' then this doesn't work, I guess
msaccess end the statement with the' character contained in [nomcli].
is there any way of solving this?
thanks,
gonzalo

[Terry Kreft]

If there are embedded apostrophes (') then you need to double them up

So
stLinkCriteria = "[nomcli] like '*" & Replace(Me![nomcli], "'",
"''",compare:=vbTextCompare) & "*' "


--

Terry Kreft
<ci************@gmail.comwrote in message
news:11**********************@35g2000cwc.googlegro ups.com...

Hi,
In my code I have the following:

stLinkCriteria = "[nomcli] like '*" & Me![nomcli] & "*' "

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

If [nomcli] contains character ' then this doesn't work, I guess
msaccess end the statement with the' character contained in [nomcli].
is there any way of solving this?
thanks,
gonzalo