Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

    Unanswered:

    Use the Nz() function to solve the problem of the Null fields. e.g. use:
    Code:
    Like "*" & Nz([Forms]![SourceSearch]![DescriptionS], "") & "*"
    instead of:
    Code:
    Like "*" & [Forms]![SourceSearch]![DescriptionS] & "*"
    Have a nice day!

  2. #2
    Join Date
    Nov 2015
    Posts
    9
    Thank you Sinndho.

    Since this morning, I have used this site to do it via VSB. This works just as expected
    http://allenbrowne.com/ser-62.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •