jiayiloo
asked on
Date Data Entry(Immediate)Verification
I created a field with data type "TIME" and it is Editable for user to key in date value(MM/DD/YY).
If user key in wrong date data ie: 12/32/1999 or 13/01/1999 or a2/b1/1999 or "abc" anything that is non-Date format;
What is the best way to immediately(b4 going to next entry field)prompt user that the date having wrong format??
Thks...
If user key in wrong date data ie: 12/32/1999 or 13/01/1999 or a2/b1/1999 or "abc" anything that is non-Date format;
What is the best way to immediately(b4 going to next entry field)prompt user that the date having wrong format??
Thks...
if u want to be tested immediately, set the form property 'Automatically refresh fields'
ASKER
Ghassan,
U R right it won't work imediately until I set the form property to 'Automatically refresh fields'.
However I have six Date fields in the form. The user need not necessary fill in all of them and some need to hide base on input criterias....
I suspect the following error message come from these fields that contain your formula.
"Field Contains Incorrect Value"
"field didn't pass validation formula"
Anyway to solve this?? Thks in advance...
Some need to It looks like
U R right it won't work imediately until I set the form property to 'Automatically refresh fields'.
However I have six Date fields in the form. The user need not necessary fill in all of them and some need to hide base on input criterias....
I suspect the following error message come from these fields that contain your formula.
"Field Contains Incorrect Value"
"field didn't pass validation formula"
Anyway to solve this?? Thks in advance...
Some need to It looks like
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@If(@IsError(@Date(fieldna