Multiple Lines In Validation Message?

  • Thread starter Thread starter Guest
  • Start date Start date
hi Daniel,
Is it possible to have multiple lines of text within the Validation Message?
Click to expand...
If you mean a table constraint, yes. Enter the line break with Ctrl+Enter.


mfG
--> stefan <--
 
I'm unsure what your TABLE CONSTRAINT means.

I have applied some validation to some data fields within one or more
tables, ie. "is not null"

And have made a message that will display when the validation rules are not
met. ie "you must enter"

Is there a way to input more than one line into this Validation Text option
for this data field?

Thank you for your help
 
hi Daniel,
I'm unsure what your TABLE CONSTRAINT means.
Click to expand...
A constraint on a table, e.g. a CHECK CONSTRAINT.
And have made a message that will display when the validation rules are not
met. ie "you must enter"
Click to expand...
Have you tried Ctrl+Enter?
Is there a way to input more than one line into this Validation Text option
for this data field?
Click to expand...
Ctrl+Enter!


mfG
--> stefan <--
 
A constraint on a table, e.g. a CHECK CONSTRAINT.
Click to expand...

That is incorrect. There is no way to set the 'validation message' for
a CHECK CONSTRAINT. It is *always*, "One or more values are prohibited
by the validation rule 'your_constraint_name_here' set for
'YouTableNameHere'. Enter a value that the expression for this field
can accept." That's why it's important to pick a meaningful name for a
CHECK CONSTRAINT (and no, a constraint name cannot contain line breaks
<g>).

Jamie.

--
 
hi Jamie,

Jamie said:
That is incorrect. There is no way to set the 'validation message' for
a CHECK CONSTRAINT. It is *always*, "One or more values are prohibited
by the validation rule 'your_constraint_name_here' set for
'YouTableNameHere'. Enter a value that the expression for this field
can accept." That's why it's important to pick a meaningful name for a
CHECK CONSTRAINT (and no, a constraint name cannot contain line breaks
<g>).
Click to expand...
Your're right. I just wanted to know if he really means a validation
rule on a table.

btw, the FoxPro guys have here an advantage:

http://msdn2.microsoft.com/en-us/library/yey80zw6(VS.71).aspx


mfG
--> stefan <--
 
Back
Top