Quick filter not working when memo-type fields in form

Television

Registered User.
Local time
Today, 15:02
Joined
May 15, 2013
Messages
31
Greetings!

I recently made a new version of our database complete with forms, querys etc.. using Access 2010. It looked good and nice, but we encountered an unexpected problem. In all forms that contains memo-type fields quick filter is not working (there is no lists, checkboxes etc..). My users really like quick filters and are understandably irritated. I would understand if this disappearance would affect only memo-type fields, but it affects ALL the fields. I also know that there are problems with memos in Access 2010. I have tried to make new forms, but every time I add memo fields quick filter stops functioning. I have also tried to change properties, options and what not, but to no use. In older versions of our forms this feature works just fine, but they were made in older version of Access (don't know which since oldest ones are from year 2003). Anyone knows reason for this and, more importantly, how to fix it? :banghead:

Thank you!

Television
 
For A2007:

Access Options>Current Database>Filter Lookup Options... >Don't display lists where more than this number of records read
 
I know this option and it was first thing I changed, but unfortunately it does not help :(.

For A2007:

Access Options>Current Database>Filter Lookup Options... >Don't display lists where more than this number of records read
 
I found a workaround for my problem. I put all the memo-type fields in separate subforms and quick filters are working again in main form. I first tried this by placing memo-fields in separate table as someone suggested somewhere else for memo-fields as a general rule, but in the end this was not necessary.
This solution is not elegant and it is needless work, but at least it is working :). I would still like to know why this problem occurred at the first place, but I guess it is one of those little IT-mysteries ;).

Television
 

Users who are viewing this thread

Back
Top Bottom