On 24/09/2008, at 3:08 pm, Richard S. Russell wrote:
The data are not being auto-entered. They're being typed in by the
end users. Sometimes, out of habit, they indicate that they're done
typing in a field by hitting the "return" key instead of the "tab"
key.
Yeah, I realise that. If entering into a FirstName field where the
auto-enter calculation is:
= Substitute ( FirstName, "ΒΆ", "" )
then returns will be stripped from the field on record commit. You
need to make sure the option "Do not replace existing value" is off.
I can't figure out how to be a hard-ass on some things and offer
gentle guidance on others with what appears to be only the single
"check by calculation" validation method.
Yes I can see how your example poses a problem. Don't know if it's
practical for you but have you considered using a plug-in to validate
by script? (eg, DoScript, ScriptFire, zippScript)
--
Tim Mansour <[EMAIL PROTECTED]>
