I've had aread through the posts re date/time issues- there are so many!
My problem seems just a little different.
I import data from an information system into Access.
The field that's giving me grief is in date/time format (although I only want the date).
I have set the property of this field in Access to Short Date, and also tried the input mask __/__/__ , but still the time is entered into the table.
I have seen the suggestion to check the regional settings in control panel (will do this when back at work tomorrow)
Is there any other way to prevent the time from being entered into the table?
Thanks in advance for your help.
My problem seems just a little different.
I import data from an information system into Access.
The field that's giving me grief is in date/time format (although I only want the date).
I have set the property of this field in Access to Short Date, and also tried the input mask __/__/__ , but still the time is entered into the table.
I have seen the suggestion to check the regional settings in control panel (will do this when back at work tomorrow)
Is there any other way to prevent the time from being entered into the table?
Thanks in advance for your help.