Link to home
Start Free TrialLog in
Avatar of Zac123
Zac123Flag for United Kingdom of Great Britain and Northern Ireland

asked on

access 2007, i need time as well as date to appear

hi all,

very simply DB in the making here.

ive got a few date/time columns. what i need is for when the date picker appears and i select a date i also need the currect time to be automatically inserted.

so the end result should be:

05/08/2011 11:35

i'm sure this is simple to do but i cant see where abouts to do it. thanks
Avatar of CCKram


I did this in the past by:
Go to the design of the table.
Select the field thats set as date/time.
In general settings for the field select format and set it to the format you like.
You CAN't select the standard format, dont work for some reason.
But you could just write: dd-mm-yyyy hh:nn
How in what format you like it in!

Avatar of Zac123


thanks for getting back. my problem is here:

if i select general, it looks good in the options but it doesnt aoppear that way in the actual column.

all the other options are only date or time - not date & time together.

seems strange to me.

Avatar of CCKram

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Zac123


oh yes of course.

thanks so much. worked perfectly