Results 1 to 7 of 7
  1. #1
    mcmcd99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    65

    Combo box limit to list doesnt limit

    I have a combo box with limit to list selected, but it doesn't actually limit to the list! It lets users enter data and save it to the list. Is there a way to change that without turning it into a dropdown box only?

  2. #2
    ssanfu is online now Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,302
    Did you set the AllowValueListEdits Property to NO?
    (right below the Limit to List property)
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,716
    Also make sure there's no code in the NotInList event.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    mcmcd99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    65
    I am so blind. That was it lol.

  5. #5
    mcmcd99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    65

    How to remove date from a timestamp

    I have a timestamp on my records that is called [tstime] and it is set to the format for 24 hours,
    but when I go to edit it from a subform it shows 11/8/2017 6:39:06 PM that format, and they have to erase all of it to enter 19:20 or whatever time it is (in military time)

    How do I have it store only the military time?

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,716
    Sounds like when you populate the field, you include the date. A date/time field stores the date and time together as a double, with the integer portion representing the date and the decimal portion the time.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    ssanfu is online now Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,302
    Why are you editing a timestamp field? A timestamp is (usually) for knowing when a record is created - nothing more.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Limit To List Property
    By data808 in forum Access
    Replies: 2
    Last Post: 12-04-2014, 12:24 AM
  2. Replies: 8
    Last Post: 10-13-2014, 02:44 PM
  3. limit to list property
    By wolfm in forum Forms
    Replies: 2
    Last Post: 10-13-2014, 01:19 PM
  4. Replies: 1
    Last Post: 04-14-2014, 01:38 PM
  5. Replies: 13
    Last Post: 11-17-2013, 03:33 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 - Senior Forums