"Type mismatch in expression" on filter

[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

 

[John Vinson]

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

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]