Results 1 to 4 of 4
  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    Date Box within a form

    I have a date box within my form which is set as a date box within the table which is all good, I want users when they click in the box to only be able to add today's date or one in the future.



    Any help would be great.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Use the ValidationRule property. Try expression: >=Date()
    Then the ValidationText property could be: Date must be today or later.
    Can also set the DefaultValue property to: Date()
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Thanks, silly question where is the property box?

  4. #4
    uncletreetrunk is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    72
    No such thing as a silly question!
    Right click on your date box go to 'Properties'
    Validation rule and text properties are under 'Data' tab

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

Similar Threads

  1. Replies: 3
    Last Post: 08-21-2012, 03:05 PM
  2. Date on a form
    By Wlbyfred in forum Forms
    Replies: 3
    Last Post: 07-26-2012, 04:31 PM
  3. Date format on Form
    By onenessboy in forum Forms
    Replies: 4
    Last Post: 12-07-2010, 06:28 AM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. set date field on form to date variable
    By laavista in forum Access
    Replies: 3
    Last Post: 06-28-2010, 03:03 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