Data Validation: Is there a capital letter

Question

Hi,Subject is the request, i'd like to know a way to detect if there is a capital letter in any given text field. Has anyone solved this?------------------------------GMacri------------------------------

markshnier__you · Answer

How about this (not tested but it should work)

IF([My Text Field], <> Upper([My Text Field]), "Data has Capitals!! Please correct the error and attempt to save again.")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

ryanstanford1 · Answer

I don't think Mark's answer will fully work... as the only way that [Field] will equal Upper([Field]) is if every letter is capitalized... not if only one such as "Mark", it would have to be "MARK".

To get the desired effect would be to have:

If([Field] <> Lower([Field]), "Field has a capital letter","There are no capital letters")

------------------------------
Ryan Stanford
------------------------------

markshnier__you · Answer

did you try it?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

ryanstanford1 · Answer

At the time of posting I hadn't... did a quick test... using your formula and mine to populate IfUpper and IfLower:
------------------------------Ryan Stanford------------------------------

markshnier__you · Answer

Ryan, you were correctIf([My Text Field] &lt;&gt; Lower([My Text Field]), "Data has Capitals!! Please correct the error and attempt to save again.")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Data Validation: Is there a capital letter