date format

[slimjen1]

all using access 2010; i have a form that includes a date field. Is there a way to force the user to only choose a month end date? When the user clicks the date from the popup, they may use 9/1/2013 when the mgr. want them to use only 8/31/2013. I am thinking validation field to put a msg but want to be able to force it not the option. thanks

 

[pr2-eugin]

Try handling this condition check in the Before Update event of the DateControl. It will not allow the user to even move to another field unless a valid value is input in it.

 

[slimjen1]

Can you give me an example? Is there specific wording for forcing the date control to use month end?