codejockey00
Programmer
I have a database that contains a memo field when performing a find on this field the find starts and then I recieve an "Invalid Arguement". Any ideas on what could be causing this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Invalid Arguement Message when searching Memo Field
- Thread starter codejockey00
- Start date
- Status
SmallCraig
MIS
codejockey,
"Memo" fields seem to be quite strange beasts - ever tried to open your table, select the memo field and then try to sort the table on it? Access greys out the sort buttons - it can't be done! I've never tried to do a find on such a field, but I'm guessing yur problem has something to do with the odd nature of "Memo" type fields.
Try generating some SQL via a QBE on the table, and use LIKE with wildcards. I'm certain that this will work - I have a program that has to do a SELECT on a memo field, and it works fine.
I wish you success,
SmallCraig![[upsidedown]](/data/assets/smilies/upsidedown.gif "[upsidedown] [upsidedown]")
"Memo" fields seem to be quite strange beasts - ever tried to open your table, select the memo field and then try to sort the table on it? Access greys out the sort buttons - it can't be done! I've never tried to do a find on such a field, but I'm guessing yur problem has something to do with the odd nature of "Memo" type fields.
Try generating some SQL via a QBE on the table, and use LIKE with wildcards. I'm certain that this will work - I have a program that has to do a SELECT on a memo field, and it works fine.
I wish you success,
SmallCraig
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question