Form level validation - date text box

[tezread]

This is rather odd.

I have a form that is not bound to a table but I need to validate it.

I have entered in the text box properties under Validation rule:

"dd/mm/yyyy"

and vlaidation txt

but even if if I follow the rule the validation text still appears!!

 

[KenHigg]

Should you use the input mask?

 

[tezread]

tried that out ken but that isn't what I need really. I tried dd/mm/yyy in input mask but now I cannot enter any dates at all. Also I need validation

 

[spikepl]

What do you wish to check for? Here is some stuff on validation rules: http://office.microsoft.com/en-us/a...-to-validate-data-in-a-field-HA010096312.aspx

Your current rule requires the input to be a string "dd/mm/yyyy" - I presume that is not what you wanted? If you want a specific format then use the input mask as suggested by Ken.

 

[spikepl]

Besides, for dates you can set the format property of the text box to the desired date format, and it will complain on its own accord, if the user enters something else.