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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top