Results 1 to 2 of 2
  1. #1
    ijo68 is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Feb 2021
    Posts
    39

    ComboBox Limit to list message - how to change it

    Hello all,
    I have a ComboBox with the "LimitToList" value set to "Yes" under the Data tab. I also have a "List Items Edit Form" that opens when the user clicks Yes on the popup prompt. see image:
    Click image for larger version. 

Name:	properties sheet.png 
Views:	16 
Size:	8.2 KB 
ID:	46266Click image for larger version. 

Name:	error prompt.png 
Views:	16 
Size:	9.2 KB 
ID:	46265. I would like to know how to change the default text in the popup message. Can anyone help ?..

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    Write your own NotInList event code.
    If you google that you should find a lot of examples.

    heres info https://docs.microsoft.com/en-us/off...obox.notinlist
    http://allenbrowne.com/ser-27.html


    Here's an example I have
    Attached Files Attached Files
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

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

Similar Threads

  1. Combo box limit to list doesnt limit
    By mcmcd99 in forum Access
    Replies: 6
    Last Post: 11-09-2017, 07:31 PM
  2. Replies: 21
    Last Post: 02-16-2017, 03:14 PM
  3. Limit Combobox list
    By gw2013 in forum Forms
    Replies: 21
    Last Post: 11-26-2015, 12:09 PM
  4. Replies: 11
    Last Post: 11-21-2014, 01:17 PM
  5. Change Combobox list after use it
    By TesZero in forum Programming
    Replies: 4
    Last Post: 07-22-2014, 02:14 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