Date Picker question

H

h2fcell

Using Access 2007.
Other than creating code to check that date selected in a date picker text
box is within a specific year, is there a way to limit a date picker text box
to a specific year?

Thanks in advance.
 
T

Tom van Stiphout

On Thu, 12 Nov 2009 08:50:01 -0800, h2fcell

No.
Such validation belongs in the control's BeforeUpdate event. If you
don't like the date you can display a MsgBox and set Cancel=True.

-Tom.
Microsoft Access MVP
 
Top