Multiple Lines In Validation Message?

[Guest]

Is it possible to have multiple lines of text within the Validation Message?

 

[Stefan Hoffmann]

hi Daniel,

Is it possible to have multiple lines of text within the Validation Message?

If you mean a table constraint, yes. Enter the line break with Ctrl+Enter.


mfG
--> stefan <--

 

[Guest]

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

 

[Stefan Hoffmann]

hi Daniel,

I'm unsure what your TABLE CONSTRAINT means.

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"

Have you tried Ctrl+Enter?

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

Ctrl+Enter!


mfG
--> stefan <--

 

[Jamie Collins]

A constraint on a table, e.g. a CHECK CONSTRAINT.

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.

--

 

[Stefan Hoffmann]

hi Jamie,

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>).

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 <--

 

[Rick Brandt]

hi Jamie,


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

The Validation Rule Text in an Access table can have line-breaks. Just use
<ctl-enter> to create them when entering the text.