How to stop Access to switch day with month when month is invalid and day is valid

[Gilmer]

I have a date field named dateffectivedate (mm/dd/yyyy). In the input I want to check that mm is between 1 and 12 otherwise give an error message. I can use datePart or Month() to extract the month of the date. My problem is that a user enters a date as 15/2/2019 where 15 is the month typed by mistake Access automatically changes the date to 2/15/2019. So when it reaches the IF statement month is correct because it was changed to 2 but that is not the month I wanted. How can I stop this switch. Is there a setting in access to stop doing this?Thanks for your help.

[JoeM]

One way to do what you want is to have the Date Entry field be a Text field. Then you can check/validate it, and assign it to a Date field.
Or, use a Date Picker instead of letting them free-form the date entry (Google "Access Data Picker control").

[June7]

See if this helps http://allenbrowne.com/ser-36.html

Otherwise, one way to deal with this is UNBOUND textbox (and/or separate UNBOUND boxes for each date part). Then code validates and saves to record, if saving to record is necessary.