Problem: I have a textbox on a form which displays the date dd/mm/yyyy, which is how I want it, but when clicking on it it adds the time to the end, which makes it not meet the requirements of the input mask, so you have to backspace the time before leaving the field.

I traced it back to the table the form gets that value from, the fields datatype is Date/Time, and the Default Value is "Int(Now()) ". If I could change it to...