Date Picker question

[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.

 

[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