Results 1 to 13 of 13
  1. #1
    yrstruly is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2024
    Posts
    122

    Drop Down Selection from a Value list

    I implemenetd a dropdown for a value selection of "A/EC;Negative;V/EC;Positive"
    Bound Column 1
    I get an edit list item display.


    ValueList.zip

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Seriously, what is the use of a docx ?
    If you can upload a file, upload the DB! :-(
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Seriously, what is the use of a docx ?
    If you can upload a file, upload the DB!

    Not even what you have posted above?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2021
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    I get an edit list item display.
    Not very clear on why or under what conditions the complaint is, but if you want to repress edits, set the property to NO:
    Click image for larger version. 

Name:	vl.png 
Views:	50 
Size:	108.0 KB 
ID:	52876

  5. #5
    yrstruly is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2024
    Posts
    122
    Thank you. I removed those comma's, but it still displays with the selection option.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Did you change AllowValueListEdits to No?

    If you want users limited to list items, set LimitToList to Yes.
    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.

  7. #7
    yrstruly is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2024
    Posts
    122
    Yes, it swows correctly, accept for "A/EC;Negative;V/EC;Positive" Comma at end.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    What shows in image is not same as in your narrative.

    I can't even get that docx file to open.
    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.

  9. #9
    madpiet is offline Expert
    Windows 10 Office 365
    Join Date
    Feb 2023
    Posts
    565
    I just built one of these for the first time in a million and a half years...
    1;"XYZ";2;"ABC";3;"ZZY"

    So I think your string should be something like this:

    "A/EC";"Negative";"V/EC";"Positive"

    (All strings are in double quotes, numbers are not delimited)

    then the column widths property: 0;1 so the first column is hidden and the second is an inch wide.

  10. #10
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Just use the wizard.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  11. #11
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Quote Originally Posted by Welshgasman View Post
    Seriously, what is the use of a docx ?
    If you can upload a file, upload the DB! :-(
    OP has the right to post the info any way they want. I have the right to not download a file, move it to a folder, unzip it and try to open it - and I usually don't.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  12. #12
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    Quote Originally Posted by Micron View Post
    OP has the right to post the info any way they want. I have the right to not download a file, move it to a folder, unzip it and try to open it - and I usually don't.
    I agree, with the exception of you, Gasman, Dave, June, Mad, and a few others I've known for years. It's a trust issue, no offense to the OP intended. My biggest pet peeve is screen shots of long code that could just as easily be copied and pasted.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  13. #13
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    And yes, until you download the zip file, you do not know it only contains a docx file?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 40
    Last Post: 04-06-2020, 06:49 AM
  2. Drop-down list values selection
    By Haleakala17 in forum Forms
    Replies: 2
    Last Post: 09-29-2012, 03:59 PM
  3. Replies: 3
    Last Post: 12-30-2011, 01:20 PM
  4. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  5. Replies: 4
    Last Post: 06-16-2011, 09: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