"Type mismatch in expression" on filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to perform a standard filter on a text field bound to a form.
When I do a find (Ctrl-F) I have no problems. However, if I try to do a
filter (Right-Click, filter fill in), I get the message:

"Type mismatch in expression"

Once I click on OK, the form appears to lock up. However, if I switch to
another task, then back again, it is no longer locked. In addition, the
filter operation was not performed.

Any ideas?

Thanks,
Leif
 
I'm trying to perform a standard filter on a text field bound to a form.
When I do a find (Ctrl-F) I have no problems. However, if I try to do a
filter (Right-Click, filter fill in), I get the message:

"Type mismatch in expression"

Once I click on OK, the form appears to lock up. However, if I switch to
another task, then back again, it is no longer locked. In addition, the
filter operation was not performed.

Any ideas?

Thanks,
Leif
Click to expand...

What field are you trying to filter? What is its datatype? Is it a
Lookup field (i.e. you see text but what's actually stored is a
number)? What are you entering as the filter?

John W. Vinson[MVP]
 
Back
Top