Can you force a user to ...

[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

 

[Rob]

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

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?

 

[Guest]

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

 

[tina]

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

I like the idea except that if someone is just wanting to look at the data

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?!