X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Sharepoint Validation Blocking Edit To List Through Access, SharePoint 2013    
post Apr 18 2019, 01:20 PM

Posts: 1
Joined: 18-April 19

We have a SharePoint site and an associated MS ACCESS application. Referrals are put in the SharePoint list through a form that validates the customer number, which must be 9 characters, numeric only. The validation rule works perfectly in SharePoint. However, if any field is changed by an agent from the ACCESS application, the validation for the customer number fails. There are only two fields that the agent can update - one is an "Accepted By" field which is just text with no validation on the SharePoint side, and the other is a "Date Accepted". In the Access application, both fields are populated in the SharePoint list by simply clicking a button.

The validation rule is pretty simple:

=IF(LEN([CustNum])=9,ISNUMBER([CustNum]+0), FALSE)

Once the record is updated from Access and the user tries to move off the record, an error is triggered by the rule, even though the customer number has not changed. It seems that the problem lies in the "IsNumber" function, as I can take that out of the rule and it will work. Any help is appreciated


Go to the top of the page
post Apr 18 2019, 02:42 PM

UA Moderator
Posts: 77,728
Joined: 19-June 07
From: SunnySandyEggo

Hi Mark,

Welcome to UtterAccess!

Just a quick question for clarification, is this rule in SharePoint or Access?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    6th April 2020 - 04:46 PM