Results 1 to 5 of 5
  1. #1
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150

    Input Mask; Date format not valid error

    Hi All,



    I have a form with a date time field with the input mask in the format 99/99/0000\ 00:00;0;_

    When reading data from the table the data displays fine 06/10/2021 10:00:00 for example

    However, when I try and modify the data I get the error message that the format of the data is incorrect (See attached screenshot)

    I can't work out what's going on or why, is my input mask wrong? Does any one have any ideas. The underlying field is just set to type date time.

    Thanks and if you need anything more please ask
    Attached Thumbnails Attached Thumbnails InputMaskError.PNG  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    It works for me. What value are you trying to input? Are you typing a number for every space? You don't include _M in the mask so are you entering 24-hr clock time?
    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
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    I'm literally in testing just changing the last digit from the 0 to a 1 for testing, that's it, nothing else has changed. Maybe I'll get rid of the text box and recreate it, sometimes Access does weird things and if it works for you. Let me try that and I'll get back to you. Thanks

  4. #4
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    Okay, yes that fixed it. Weird Access.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    The Access Gnomes do like playing games with users!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. date/time input mask and date ordering
    By jsberry in forum Database Design
    Replies: 1
    Last Post: 06-19-2017, 01:04 PM
  2. Replies: 1
    Last Post: 06-29-2014, 01:40 PM
  3. Table Column Format/Input Mask
    By mkc80 in forum Access
    Replies: 7
    Last Post: 11-23-2012, 02:27 PM
  4. Custom (?) Date Input Mask
    By SeaTigr in forum Access
    Replies: 3
    Last Post: 11-07-2011, 02:40 PM
  5. Custom Data input mask or format?
    By RiverAnimal in forum Database Design
    Replies: 2
    Last Post: 12-06-2010, 09:58 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