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
------------------------------
Original Message:
Sent: 11-25-2019 13:35
From: Mark Shnier (YQC)
Subject: Data Validation: Is there a capital letter
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
Original Message:
Sent: 11-25-2019 13:20
From: G.Macri G.Macri
Subject: Data Validation: Is there a capital letter
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
------------------------------