Hi,
I have produced a couple of other Access databases where, in the Table
design, I have selected Short Date and only the date has been stored in the
table. In the current database I am working on I have selected Short Date on
table fields but find that the date AND time is being saved. This is causing
problems whem I want to seach by date.
Can anyone suggest why, on this occasion, Short Date format is causing date
and time to be saved (like the General Date format) when data is entered
through a form (where the control is also set to Short Date format)? The
problem is evident on all the date fields I have created in all tables in the
database.
Thanks for any assistance you can offer.