Convert date from short date to general date

[cebrower]

I have a table with a date field that was originally defined as short date. I would like the existing records to to be converted to general date. I've changed it in the table definition and new records now display as general date, but the existing records still displays as short date. Any suggestions?

[Minty]

The short date and general date fields are one and the same - An Access datetime field.
The short date format option just determines the display mode, and removes the visible time element, which will probably be 00:00 (Midnight)
By default in a table access suppresses the time value when it is 00:00.

This format can be overridden on a form or report to the presentation mode of your choice, it has no bearing on what is stored.

[isladogs]

As you already know, short date won't show time component whereas general date does so.
However no matter what the format, dates are stored as double numbers e.g. 6am today is stored as 43578.25
If no time is specified, Access will assume a time of 00:00 and store the value as 43578.00
It will just display the date without the time component

That is exactly what you have for all your existing records which is why no time is shown

[cebrower]

The the date field in the existing records was populated in VBA using Me!ActionDate = Date. The new records are populated using me!ActionDate = Now. So if I understand correctly, the existing records don't include the time, only the date,

[Minty]

Correct. The Date() function inserts the date only which defaults to 00:00 time value, as Colin stated above.
Now() inserts the current date and time.