Handleing apostrophes

[JimO]

The code shown works until I come to a name with an apostrophy such as "Carroll O'Conner" then I am getting a blank. Any solutions?

    SeriesList.RowSource = "SELECT [TVID], [TVSeries], [Overall#], [Season], [SeasonNum], [Title], [Director], [Writer], Format([DateAired],'ddd-mmm d/yyyy'), [Plot]" & _
                            "FROM TVEpisodeListQ WHERE (Writer) LIKE '" & WriterCmb & "';"

Thanks


Jim O

[rpeare]

enclose your writer name in double quotes instead

"FROM TVEpisodeListQ WHERE [Writer] like """ & writercmb & """;"

because you are attempting to insert double quotes inside double quotes you need to double them up

i.e.

if I wanted a string to just be " I would need something like

str = """"

four double quotes the outer quotes set the bound of the string the inner quotes must be doubled to produce the single quote string

[JimO]

Works great, thank you.

Jim O