Enforcing Case Requirements in Field Validations

Enforcing Case Requirements in Field Validations

These expression examples show how to enforce uppercase, lowercase and titlecase requirements on a field. Field Validation rule to make a Field require all CAPITAL letters: =IIf(FindOneOf([<ContactFirstName>],'abcdefghijklmnopqrstuvwxyz')>0,'-1',[<ContactFirstName>]) Field Validation rule to make a Field require that just the first letter be CAPITAL: =IIf(FindOneOf(Left([<ContactFirstName>],1),'abcdefghijklmnopqrstuvwxyz')>0,'-1',[<ContactFirstName>]) Field Validation rule to make a Field require that just the first letter be lowercase: =IIf(FindOneOf(Left([<ContactFirstName>],1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ')>0,'-1',[<ContactFirstName>])