Thanks for quick reply... below is the query.
SELECT [Articles].Date1, [Articles].Date, [Articles].[Article Name], [Articles].Publication, [Articles].Author, [Articles].[Full Text], [Articles].RecordId
FROM [Articles]
WHERE ((([ Articles].[Full Text]) Like "*'" & [Forms]![Search...