T
Tony Williams
I have a database that was designed in Access 2003. There are a number of
forms with date controls of varying formats eg ddmmyy and mmyyyy However we
have now upgraded to Access 2007 and on all the forms where there are date
controls there now appears the calendar pop up alongside the date control.
This causes a problem because some of the users click on this and insert a
date like 30/04/09 when the format of the date should be April 2009. So I
know I can go into every form and change the property of the date control to
Never but is there a way of changing the property using VBA code which would
look at every form and every date control and switch off the popup?
I'm not a VBA expert but willing to try
Thanks
Tony
forms with date controls of varying formats eg ddmmyy and mmyyyy However we
have now upgraded to Access 2007 and on all the forms where there are date
controls there now appears the calendar pop up alongside the date control.
This causes a problem because some of the users click on this and insert a
date like 30/04/09 when the format of the date should be April 2009. So I
know I can go into every form and change the property of the date control to
Never but is there a way of changing the property using VBA code which would
look at every form and every date control and switch off the popup?
I'm not a VBA expert but willing to try
Thanks
Tony