My Assistant
![]() ![]() |
|
|
Sep 12 2007, 10:41 AM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 59 From: ooooooohio |
I'm still learning - so for me this is not a goofy question. I have a form that requires a date to be filled in. Initially the control is blank. I do not want them to be able to close the form without a date being entered (unless they click the 'exit without saving' command that I have working just fine). I've experimented (and read) on how to validate that the date has been entered but have not come up with the solution where it works.
|
|
|
|
Sep 12 2007, 10:43 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 31,413 From: NC, USA |
Hi,
use the before update event of the control or form e.g.: If Not IsDate(Me.YourControl) Then Cancel = True msgbox("please provide a valid date!") End If HTH Good luck |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 05:32 PM |