Thread: Bound Date/Time field to automatically display the current date
View Single Post
  #2  
Old September 20th, 2009, 10:44 PM posted to microsoft.public.access.tablesdbdesign
Douglas J. Steele[_3_]
external usenet poster
  
Posts: 3,143
Default Bound Date/Time field to automatically display the current date
Set the DefaultValue of the field in the table to Date.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Billiam" wrote in message
news
I have a bound form which has a field called WorkDate which I would like to
default to todays date...it also still needs to be able to be changed to a
different date. I have tried inserting =Date() in the On Load event of the
Bound Worked Date field, but no luck...the picker is still just sitting
there
with nothing in the field.

Thank you for any help!
Best Regards,
Billiam