title: Access 2010 - limit date range in date picker
body: <p>I am using Access 2010 on Win 7 pro.</p>
  
  <p>I am trying to limit the dates returned in a date picker associated with a text box on an access form. </p>
  
  <p>I have created the text box set its format to short date and selected on dates in the show date picker property. So far so good I am seeing the date picker icon next to the field when it has the focus as expected and the date picker is working. </p>
  
  <p>What I am having trouble with is limiting the dates shown in the date picker to only the last two weeks, this is required due to business rules. I can raise an error in the afterupdate event no problems but its not pretty and I would prefer to limit the user to a specified range. I have been all over the web and found many references to how this was done with calendar active x controls and the activex date picker in previous versions. The code to do it is not a problem I just cant find anywhere to limit what the date picker displays. </p>
  
  <p>Any help greatly appreciated </p>
  
  <p>PK      </p>