TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello, I have a form which contains about a dozen data entry points.
A lot of them are mandatory and so I have some validation that basically says if the field in question has no data in then generate an error message and return them to where they were.
Except I now see from the database that sits behind the form that the users have been entering full stops or commas to fool the form into thinking it's been populated correctly.
Is there some validation I can apply? I have introduced something along the lines of "if the field in question contains less than five characters then reject" but that won't stop the users entering six full stops.
Many thanks for reading.
A lot of them are mandatory and so I have some validation that basically says if the field in question has no data in then generate an error message and return them to where they were.
Except I now see from the database that sits behind the form that the users have been entering full stops or commas to fool the form into thinking it's been populated correctly.
Is there some validation I can apply? I have introduced something along the lines of "if the field in question contains less than five characters then reject" but that won't stop the users entering six full stops.
Many thanks for reading.