Page History
...
Pos | Name | Type | Description | Default |
---|---|---|---|---|
<1> | Validation Pattern | Text | The cell's validation pattern | "None" |
<2> | Conversion Pattern | Text | The cell's output conversion pattern | "None" |
<3> | Validation Message | Text | The cell's message to display when data is invalid | "" |
<4> | Show Message Flag | Boolean | Determines if the cell should display the validation message or simply pass it on to the OnInvalidData event | 1 |
<5> | Highlight Text on Cancel Flag | Boolean | Determines if the invalid text should be highlighted instead of just leaving the cursor where it is | 1 |
<6> | Disable Validation | Boolean | Determines if the table's automated validation is disabled | 0 |
...
The validation message is the text to be presented to the end user when the data is recognized to be invalid. If there is no validation pattern, then this field is ignored. Furthermore, if this field is empty, no message will display. This text is always passed via the Message parameter of the OnInvalidData function for convenience, but you can have the Edit Table show the message for you (see below).
...
The @DATA string is only replaced when the edit table shows its own message. If you opt to capture the OnInvalidData event instead, then the @DATA string is not replaced.
...
This flag is where you choose how to handle invalid data. If you set this to 1, which is the default, then the edit table will show a standard message box with the message you supplied above. If no message was supplied or if you set this field to 0, then the OnInvalidData event fires instead.
Highlight Text on Cancel Flag
This flag allows you to specify the behavior of the cursor when data is invalid. If you set this to 1, which is the default, then the entire cell is selected. If you set this to 0, then the cursor remains in its previous position. Note that this flag is ignored if the Show Message flag is turned off. If the OnInvalidData event is used to display error messages then use the Cancel property to control the behavior of the cursor.
...
By default, the table will always attempt to validate the cell's data against the Validation Pattern. If, however, you merely want to store the validation in this property but perform the validation check yourself, you can set this flag to 1 to disable the automated validation. In this case, you would want to use theBeforeUpdate event to perform the validation manually.
...