使用ADODB在Filter上输入撇号时VB6获取错误

I'm trying to filter datagrid from a textbox it works but not if apostrophe or ' was typed on the textbox, I'm using ADODB and VB6I'm trying to filter datagrid from a textbox it