Connecting Tech Pros Worldwide Forums | Help | Site Map

Need to get Created date in one of the input field

Newbie
 
Join Date: Jul 2008
Posts: 1
#1: Jul 14 '08
Hi Guyz,

I am new to Access Databases. My question looks to be very simple.
I have created a textbox.I want to display the creation date of the file in that box.
What needs to be done. ?

I have given Format attribute as 'Long date' and the Control Source as '=Now()'.
But it is giving me the current date only. But I want the creation date.

Can anyone helpe me out ?It is kind of urgent.

Regards,
SP.

puppydogbuddy's Avatar
Expert
 
Join Date: May 2007
Location: Florida
Posts: 1,915
#2: Jul 14 '08

re: Need to get Created date in one of the input field


Remove the expression = now() from the control source property and place it in the default value property of the textbox. That should place the date and time in the control at the time the record is created. The default value should not change unless it is overridden by the user. If you want to prevent it from being overridden, you need set the "enabled" property of the textbox to no.
Reply


Similar Microsoft Access / VBA bytes