If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Type mismatch in expression" on filter
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 |
#2
|
|||
|
|||
On Thu, 30 Jun 2005 12:31:05 -0700, "Leif"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data type mismatch in criteria expression | Jeff | Running & Setting Up Queries | 4 | June 10th, 2005 03:11 PM |
Alphanumeric Part #'s and Type Mismatch | [email protected] | General Discussion | 1 | May 24th, 2005 04:24 PM |
Data type mismatch in criteria expression error returned... | Rashar Sharro via AccessMonster.com | Running & Setting Up Queries | 3 | April 28th, 2005 08:49 PM |
type mismatch error | Christopher Glaeser | Setting Up & Running Reports | 4 | November 25th, 2004 07:47 AM |
Query Should run but Data Type Mismatch error | news.paradise.net.nz | Running & Setting Up Queries | 1 | September 9th, 2004 01:19 PM |