Question Locked

How to filter a memo field in access 2007?

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created one button for my form to do a "filterbyselection". It works with all the different types of fields but not with the memo field.

The error that I get is the '2046'

I have searched in so many forums but without luck. What can I do??

Please HELP!!!!

THANKS

6 replies

by tony hopkinson

because it's a memo, ie an entire word document or some such.

Even if it worked think of the cost of comparing entire documents for equivalence.

So if if MS had implemented it you'd have to be insane to use it.

Not going to be easy to get round either. If you have filter by everything else, there should n't be that many to look at and everything else should give you a far better indicator of which record you want to select.

by eitiu

Ok, It's sad but if it is not possible then I won't lose more time with it.

Thanks for your answer!!

by eitiu

If I use the filter by selection button located in the MSAccess toolbar, the filter in the memo field works perfectly.
Then, making my own button i a form it should also be possible.
I use a memo field for text but it will never have more than a 1000 caracters.

by tony hopkinson

Still don't like it though.

How many records are going to end up in this table?. I'd do a few tests with your maximum projected number of rows if I were you.

by eitiu

only 500 registers...number of rows 10.

I have been working in other type of filters and with all them I do have problems, making my own commandbuttons.

1- If I make a filter by selection button, it works but it filters all the registers that have exactly the same information. I mean if I just want to see the registers that contains only the selected characters, how would I program my button?

2- I also would like to make a button of filter by form. When I introduce the text to filter, then I can not apply the filter, all the buttons I created become grey and they can not be pressed.
3- If I want to filter by selection a memo field, but It is not working. Is there any way to filter memo fields?
As you can see I need help!!!!!!!

Thanks

This discussion is closed to new replies.