Sharepoint Custom list field Custom validation message not coming up

Question

_{Tuesday, November 8, 2011 6:52 PM}

I am aware that people have faced this issue and seems like a problem with SP itself,but wanted to know if we have a good solution for the same.

Problem: Have a sharepoint  custom list with a text column.have a custom validation formula on it and a User message as well.But when validation fails custom messge does not come up.

I do not want to use designer here as i cannot use it in production environmnt...any other suggestions.

All replies (5)

_{Friday, November 11, 2011 8:16 AM ✅Answered}

Hi,

Please check if the site is created using a site template which has an item validation formula to a list. If so, this KB article can help you: http://support.microsoft.com/kb/2479788

The error message “The validation formula has evaluated to an error” is the default validation failure message. Go to List Settings> Validation Settings, make sure you have typed the user message for the formula.

Xue-Mei Chang

_{Tuesday, November 8, 2011 7:30 PM}

Hi

check this doc

http://srikanthmicrosoft.blogspot.com/2010/06/column-validation-in-sharepoint-2010.html

Check if in your validation formula is OK, as you can see the explanations in doc

Romeo Donca

_{Wednesday, November 9, 2011 10:41 AM}

I am using a regular expression on a single line text column.Regarding which the link has not mentioned.Validation in my column works as per thye formula i have put,but message is "The validation formula has evaluated to an error" not the one that i have given.

_{Sunday, November 20, 2011 2:20 PM}

I have gone to the List settings and given the user message,but it is not reflecting.The validation works fine but message is the default one.

_{Thursday, May 17, 2012 3:22 PM}

Did you figure out any way around for this error. If yes please let me know, I am running through the same error.