Error message setup

[ppatane]

I need to test the inputted data for the following conditions, and then display an error message with the record # of the error.  The first column called Ref1 is numeric data formatted as text due to necessary leading zeroes.

error if data in Ref1 column is not numeric characters

error if data in Ref1 column is 00000

error if the 7th character in a field is anything other than a dash

error if  the length of a column is other than 11 characters 

I have used the Message command previously to display errors for positive tests (e.g. x=0, name = 'George', etc.) But the exclamation-point errors out instead of negating the positive statement.when I use it in the error message tool.

What am I missing here?

[binuacs]

@ppatane The first condition and the third condition contradict each other. The first error says error out if it is non-numeric and the third says check for the 7th char which is not '-', then error out.

[ppatane]

@binuacs My apologies for my poor communication
The first 2 rows refer to one field, the last 2 rows refer to other fields

[binuacs · Accepted solution]

@ppatane One way of doing this