locked
Validation Rule errors in Sharepoint Access App RRS feed

  • Question

  • I'm trying to add a "Validation Rule" to a table field in an SharePoint Access App, but every time I try keeps throwing error:

    Invalid Expression, you may have entered a common without a preceding value or identifier.

    [Charity Contact Email] Is Null OR (Like "?*@?*.??*" And Not Like "*[!a-z@=.^_$%!#&'`{|}*?~/-]*")



    • Edited by IvanFisher Saturday, January 28, 2017 5:42 PM
    Saturday, January 28, 2017 5:21 PM

Answers

  • Figured this out. Everything had to be fully qualified:

    [Charity Contact Email] Is Null Or ([Charity Contact Email] Like "?*@?*.??*" And [Charity Contact Email] Not Like "*[!a-z@=.^_$%!#&'`{|}*?~/-]*")

    • Marked as answer by IvanFisher Saturday, January 28, 2017 6:26 PM
    Saturday, January 28, 2017 6:26 PM

All replies

  • Figured this out. Everything had to be fully qualified:

    [Charity Contact Email] Is Null Or ([Charity Contact Email] Like "?*@?*.??*" And [Charity Contact Email] Not Like "*[!a-z@=.^_$%!#&'`{|}*?~/-]*")

    • Marked as answer by IvanFisher Saturday, January 28, 2017 6:26 PM
    Saturday, January 28, 2017 6:26 PM
  • Hi IvanFisher,

    It is very happy that you have resolved your problem.

    Thank you for your sharing and it will help others have the same issue.

    Best regards,

    Sara Fan


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Monday, January 30, 2017 6:59 AM