Results 1 to 6 of 6
  1. #1
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6

    Search Form Help


    I set up a simple multi-field search form for my resume database, and for the most part it works fine. It uses the fields First Name, Last Name, Address, City, State. However, the actual field with the whole resume on it is a Memo data type, and the search is not working for it. I will put in a specific word from the Resume, but all of the resumes will come up each time I run the Query. Any suggestions on how I can limit my results for the resume field to find resumes only with the key terms that I put in my search form? Thanks for any help you can give.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Access uses only the first 255 characters of Memo type field for sort and search. Review http://office.microsoft.com/en-us/ac...005274573.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6
    Quote Originally Posted by June7 View Post
    Access uses only the first 255 characters of Memo type field for sort and search. Review http://office.microsoft.com/en-us/ac...005274573.aspx

    is this true of all versions of Access? up through 2010?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Here is a more recent article. http://office.microsoft.com/en-us/ac...102505209.aspx
    It doesn't specify if the sort/search is limited. Everything I find indicates the limitation is still valid. Maybe this has something helpful (I can't get the video to run) http://www.youtube.com/watch?v=YyPsYyOXb7s
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    workinstiff is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2012
    Posts
    6
    Thanks for all your help June7! I recently upgraded to Access 2010 and they did change the limits. you can search through the whole memo. So now I can do a keyword query to find which memos in my table contain certain keywords, but I was hoping to have it so that it would then also highlight the keywords inside the text block so that it's easier to find. do you know if this is possible to set-up/how I would do that? thanks a bunch

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Emphasizing (color, font, size) substrings in text data requires Rich Text Formatting. I never used. Suggest you do some research on RTF.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 08-08-2012, 03:28 PM
  2. Replies: 5
    Last Post: 07-13-2012, 01:15 AM
  3. Replies: 1
    Last Post: 04-20-2012, 03:16 AM
  4. Replies: 12
    Last Post: 03-22-2012, 02:48 AM
  5. Replies: 9
    Last Post: 02-15-2011, 03:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums