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    
post Dec 2 2017, 06:29 AM

Posts: 277
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.


M S Narayanan

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

UtterAccess VIP
Posts: 10,169
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.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    21st October 2018 - 05:06 AM