Results 1 to 3 of 3
  1. #1
    evaraine is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    1

    Only adding default date when actually entering a new record.

    Hi,

    I am relatively new to building access databases. I am able to add today's date as a default but the problem is that it is always visible in what would be the next record even if I am not adding one. I only want this default date to appear if I am actually adding a new record. I have been searching for an answer for this in forums and tutorials all morning but can't seem to find a solution.

    Does anyone know if this is possible and could point me in the right direction?

    Many thanks.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    If you remove it from the table then it won't show up as you see it. But then you will have to put it there manually in the BeforeInsert event (if you are using a form) or somehow run a query when a new record is added.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,845
    assuming the default value in the field is set to date(), in your form, change the default value for the date control to Null.

    It will not be populated until you start to add a new record - so the new record line will be blank

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 12-31-2015, 09:39 PM
  2. Replies: 11
    Last Post: 07-20-2015, 12:58 PM
  3. Replies: 8
    Last Post: 12-29-2014, 08:13 AM
  4. Replies: 5
    Last Post: 11-18-2012, 01:27 PM
  5. Adding the Date & Time record added
    By jo15765 in forum Access
    Replies: 2
    Last Post: 11-26-2010, 11:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums