Results 1 to 3 of 3
  1. #1
    SFC is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    47

    Date picker


    I have a form that has a text box and the data for the text box is =Date(). When I run the form there is a small date picker next to the text box, I click on it and a calendar appears, I choose a date on the calander that I want however, it always defaults back to the current date. Is there a way to keep any date chosen in the calander picker when running the form?

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by SFC View Post
    I have a form that has a text box and the data for the text box is =Date(). When I run the form there is a small date picker next to the text box, I click on it and a calendar appears, I choose a date on the calander that I want however, it always defaults back to the current date. Is there a way to keep any date chosen in the calander picker when running the form?
    Yes, take out the =Date() part from the control source and bind it to a field instead. If you use =Date() as the control source then that is it and you can't change it.

    You can use

    =Date()

    for the DEFAULT VALUE property so that it enters that when a new record is created but you can then go back and change it.

  3. #3
    SFC is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    47
    Thank you Bob,
    That works just like I wanted, and thanks for the tip about the default value.

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

Similar Threads

  1. Date Picker?
    By gazzieh in forum Forms
    Replies: 9
    Last Post: 02-09-2013, 09:35 AM
  2. Date Picker doesn't appear
    By revnice in forum Access
    Replies: 9
    Last Post: 01-09-2012, 08:36 AM
  3. Date Picker
    By kelly in forum Database Design
    Replies: 3
    Last Post: 09-15-2011, 12:42 PM
  4. Date Picker
    By otisdaddy in forum Database Design
    Replies: 2
    Last Post: 07-01-2011, 12:30 PM
  5. Date picker
    By BI4K12 in forum Access
    Replies: 1
    Last Post: 06-09-2010, 11:11 AM

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