Mendip Data Systems

Database applications for businesses and schools


Example Apps for Businesses, Schools & Personal Use

Version 1.0      Updated 30/01/2018               Approx 90 kB


This is a replacement date picker with no Active X controls and can also be used in 64-bit Access.


It was originally posted in this thread at Access World Forums in May 2017


The calendar form is loosely based on open source code by Brendan Kidwell from 2003 which can be found here:


However, I've made extensive changes to the appearance of the calendar form


If all you want is a visual calendar, it will certainly do that

However, its main purpose is to input a date in a form textbox

All you need for that is one line of code in the textbox click event:



A Better Date Picker  

Click the image to view a larger version ...


CERT Version 1.43



Private Sub txtDate_Click()

   InputDateField txtDate, "Select a date to use this on your form"

End Sub


The string "Select a date to use this on your form" is used for info on the form and can be adapted to suit


To use, copy frmDatePicker & modDatePicker to your own database

Ignore frmMain - its only needed for the example app



Click to download:  Better Date Picker     (zipped)

Return to Example Databases Page