Ken-
That's difficult. If the cursor ever lands in the control, you can use On Exit to see if the user entered anything valid. Failing that - and assuming the current record is otherwise "dirty" (something has been changed), you can use the form's Before Update event to check the field.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 5, 2015, at 8:29 PM, kenaf42@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Access 07,
In a simple form I have a date field that sometimes end user leaves it blank. Please help with code that mouse curser would not move out of this date field unless proper date format is entered.
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar