How to stop users from entering certain characters

Followers

October 7, 201312 yr

Hello all,

I've FM 5.5 for Mac.

I've a text field where I want to enter a validation by calculation where users are unable to enter any spaces, commas, dashes, periods or semicolons.

What calculation may I use?

Best,

Solved by comment

October 7, 201312 yr

Go to solution

October 7, 201312 yr

I've FM 5.5 for Mac.

Your profile says FM 12. Which one's correct?

October 7, 201312 yr

Solution

users are unable to enter any spaces, commas, dashes, periods or semicolons.

Try =

not PaternCount ( YourField, " " ) and not PaternCount ( YourField, "," ) and so on...

2 weeks later...

October 21, 201312 yr

Author

Try =

not PaternCount ( YourField, " " ) and not PaternCount ( YourField, "," ) and so on...

Thanks Comment, worked perfectly!

Your profile says FM 12. Which one's correct?

Hi Eos, I've both but this particular DB I was working on was on 5.5. Comment's formula did the trick, thanks anyhow. Best!

October 21, 201312 yr

DLM,

Hi Eos, I've both but this particular DB I was working on was on 5.5.

Perfect.

October 21, 201312 yr

As a suggestion you could use the calculation option and the filter command to show only acceptable characters. This has the advantage of being more transparent to the user without an annoying validation dialog.

October 21, 201312 yr

As a suggestion you could use the calculation option and the filter command to show only acceptable characters. This has the advantage of being more transparent to the user without an annoying validation dialog.

Alas, filter wasn't available in FM5.5; it debuted in FM 7