@Tera
I believe that this can be solved by changing windows regional settings.
I completely understand, and don't blame you at all. I am just pointing out that is actually one solution. I was able to reproduce your problem (format set to yyyy/mm/dd hh:mm:ss, but hours still showed 1 digit), and then changing that setting, suddenly the Access setting worked. Maybe you could use automation to do a one time fix on your users' computer, maybe not.I can not go changing personal settings of all PCs in a company with tens or hundreds of PCs.
I think format is sitting there to prevent the need of changing any settings outside of Access.
It works for me. If you want to provide db for analysis, follow instructions at bottom of my post.
I think that the problem is that Access is not seeing the value as a date. Access is very limited in the SQL Server date formats that it recognizes. Make sure your date is defined as datetime in SQL Server. If it is anything else, that is your problem. You will get illogical sorts and compares if you are using strings as dates when the windows settings are AM/PM rather than a 24 hour clock.
The easiest solution is to fix the data type in SQL Server if you are allowed to do that. The second solution, is to update your SQL Server driver but this would have to be done on ALL computers. Your desktop support people should be able to help you with this "push".
The default driver "SQL Server" probably hasn't been updated in 15 years and so it doesn't support any date data type that I am aware of except datetime.
ODBC;DRIVER=SQL Server;SERVER=Server;DATABASE=Receiption;Trusted_Connection=Yes
Still the same. Single digit hour.Well, this is a crazy shot in the dark, but since that is a form, try making the .ControlSource something like Format( CDate(fieldname), "yyyy/mm/dd hh:nn") -
year(n) & "/" & right("0" & month(n),2) & "/" & right("0" & day(n),2) & " " & right("0" & hour(n),2) & ":" & right("0" & minute(n),2)