How to stop users from entering certain characters

[DLM]

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,

 

[eos]

I've FM 5.5 for Mac.

 

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

[comment]

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

 

Try =

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

[DLM]

 

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!

[Lee Smith]

DLM,

 

 

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

Perfect.

[Aussie John]

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.

[doughemi]

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

[Aussie John]

version 5.5 seems such a long time ago