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
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
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
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
Thank you. I removed those comma's, but it still displays with the selection option.
![]()
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.
Yes, it swows correctly, accept for "A/EC;Negative;V/EC;Positive" Comma at end.
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.
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.
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
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
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
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