Results 1 to 2 of 2
  1. #1
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55

    Report Date validation?

    access 2007,
    In my report I have a unbound text box that the user will use to enter the file date which could be earlier than the current day. In my control source I am using the code below:

    =[enter date as mm/dd/yyyy]

    This works fine and appears on the report when run and printed. What I would like to do is set some kind of data validation so they can not input the date any other way except for the short date format above. Right now it will accept anything you enter.

    Any ideas?
    Thanks,
    Bruce D.

  2. #2
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    If you click on the text box in design view and go to properties and change the format of the text box to dd/mm/yyyy, and then lock the text box that may work

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

Similar Threads

  1. Time and Date Validation
    By KEVWB in forum Access
    Replies: 1
    Last Post: 03-06-2011, 08:31 AM
  2. Date validation on form
    By accessnewbie in forum Access
    Replies: 6
    Last Post: 01-18-2011, 11:03 AM
  3. validation to populate date?
    By andyf80 in forum Access
    Replies: 3
    Last Post: 02-26-2010, 09:53 PM
  4. Date Related Validation
    By ldare2000 in forum Access
    Replies: 1
    Last Post: 11-12-2009, 10:49 AM
  5. Validation Rule: Date
    By krymer in forum Access
    Replies: 0
    Last Post: 08-27-2008, 03:30 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