title: How to find words in a memo field with microsoft access
body: <p>This is more complex than I thought as I need to do it with VBA. So here is my problem:-</p>
  
  <p>I have two tables in an MS Access DB, content and adjectives. </p>
  
  <p>The content table has over 5,000 text snippet rows in a memo field (content) and a blank text field (adjective).
  The adjectives table has 120 adjectives with the field (adjective).</p>
  
  <p>I need to check if the text snippet contains any of the adjectives and if so, add the adjective to the adjective field. If there is more than one adjective just add the first one.</p>
  
  <p>Here's an example of the data:-</p>
  
  <p>CONTENT</p>
  
  <p>"The N8 camera is pretty amazing, will it bring the N8 full on sales success though alone? It's the only "wow" factor of the handset but other handsets have 720p that are also very good such as the Sony Vivaz which a family member has and the videos are pretty amazing from it too."</p>
  
  <p>ADJECTIVES</p>
  
  <p>afraid<br>
   agreeable<br>
   amused<br>
   ancient<br>
   amazing<br>
   angry<br>
   annoyed<br>
   anxious<br>
   arrogant<br>
   ashamed<br>
   average<br>
   awful<br>
   bad<br>
   beautiful<br>
  etc<br></p>
  
  <p>How would I go about doing this is an update query or in VBA?</p>
  
  <p>Thanks in advance for your help.</p>
  
  <p>Jonathan</p>