UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Setting Default Date In Form, Access 2013    
 
   
msnarayanan
post Dec 2 2017, 06:29 AM
Post#1



Posts: 229
Joined: 28-May 13



Dear all

I have created two forms and both forms have a date field.
Now the situation is that I have to enter data for earlier period/
Dates. Every time I have to enter the date field by clicking
Calendar and it is time consuming.

I want to have default date with a flexibility to change the
Date to enter data/records for the default date.

If this can be done using unbound text, kindly help me as
to how can this be done.

Thanks

M S Narayanan

Go to the top of the page
 
projecttoday
post Dec 2 2017, 06:50 AM
Post#2


UtterAccess VIP
Posts: 8,684
Joined: 10-February 04
From: South Charleston, WV


You want to be able to change the default date of a field on a form? This would only affect new records. To do that, put a default date field (textbox) in the header section of the form. Set the default value of your date in the after update event of the header date.

--------------------
Robert Crouser

My company's website
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 01:20 AM