Memo field can not be used in formula.

See more:

CrystalReports

Dear all
I am using crystal report 8.5 in my project but i am having a problem when i want to show records based on a particular field.
I have a field departments which is text field in access. when i use the following code i am getting the following error


Run time error 20515
Memo field can not be used in formula.

My code is a under
Connection 'database connection
With CrystalReport1
.ReportFileName = App.Path & "\report1.rpt "
.WindowState = crptMaximized
.ReplaceSelectionFormula "{department.departments}= '" & Trim(Text2.Text) & "'"
.Destination = crptToWindow
.Action = 1
End With

please help
Sarfaraz