Inputting Date format

[mauni]

Hello

I have a textbox, to which user has to input installation date.

Access form only accepts the date to be input in format YYYY-MM-DD.
But when i run a search, the result shows the date in format DD.MM.YYYY

I want the user to be able to input the date in format: DD.MM.YYYY
I activated the "Date picker" and set "General date". But when i try to save it, it says type mismatch.


Help

 

[Rich]

Try the Windows Regional settings

 

[mauni]

I was able to succed with code:

<MyString> = Format(<textbox>, "yyyy-mm-dd")