Can you force a user to ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form with controls which are used to input the date. I have added a double-click event that call the Lebans' calendar. This permits me to be garanteeded as to the format of the entry. Is there a way to force the user to use this interface and not allow them to enter the date using the keyboard?

Thanks,

Daniel
 
My suggestion would be to use the GotFocus event rather
than a double click event to pull up the calendar. This
would force the calendar to be used whenever the field
becomes the focus of data entry.
-----Original Message-----
Hello,

I have a form with controls which are used to input the
Click to expand...
date. I have added a double-click event that call the
Lebans' calendar. This permits me to be garanteeded as to
the format of the entry. Is there a way to force the user
to use this interface and not allow them to enter the date
using the keyboard?
 
If you really want to be sure a date is valid, why not use

IsDate(myDate)

?

isdate("2/29/2000")
returns true

isdate("2/29/2001")
returns false
 
try using the same event, but put your "show calendar" code inside an If
statement, as

If IsNull(Me!MyDateControl) Then
ShowCalendar
End If

hth


Daniel said:
I like the idea except that if someone is just wanting to look at the data
Click to expand...
they will trigger the calendar when tabing through the form's controls? Is
there another way to handle this issue that would avoid this problem?!
 
Back
Top