Searching Memo Field For Text Strings 
Author Message
 Searching Memo Field For Text Strings

Hello,  I am involved with writing a Access 2000 application in which I
need to search a memo field for occurances of strings.  I have not found
any thing in VBA or VB 6.0 that allows me to search this field type.  I
have been able to cast the memo field over to string (->65k) without
problem, but am troubled by the lack of methods to parse substrings out
of it.  I was hoping to avoid writing a parsing routine, but can if
necessary.  Any suggestions would be greatly appreciated - Thanks Todd


Sat, 08 Jun 2002 03:00:00 GMT  
 Searching Memo Field For Text Strings
Try this -

SELECT Table1.MemoField
FROM Table1
WHERE (((Table1.MemoField) Like "*your string*"));

Jim Ide

Quote:

> Hello,  I am involved with writing a Access 2000 application in which I
> need to search a memo field for occurances of strings.  I have not found
> any thing in VBA or VB 6.0 that allows me to search this field type.  I
> have been able to cast the memo field over to string (->65k) without
> problem, but am troubled by the lack of methods to parse substrings out
> of it.  I was hoping to avoid writing a parsing routine, but can if
> necessary.  Any suggestions would be greatly appreciated - Thanks Todd



Sat, 08 Jun 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Help - Searching Memo Fields For Multiple Strings

2. Need Help - Searching Memo Fields For Strings

3. SQL Searching For Text in Memo Fields with Binary Data Included

4. MEMO FIELDS - displaying as string text

5. Append memo field to a different memo field

6. Memo fields - problems reporting 2 memo fields

7. How can I search a Memo Field in code

8. Search an replace in memo fields

9. Large Memo field search and replace error

10. Searching memo fields??

11. Large Memo Field search fix from Microsoft

12. Searching a Memo field in access 2.0

 

 
Powered by phpBB® Forum Software