Solved ComboBox.ShowOnlyRowSourceValues (Access) Problem. What it do, exactly?

[Misionero]

I understand that this property allows you to choose whether manually written options that are outside the origin of the list are shown in a combo box dropdown or a list box.
Here's an example: Field Products with values "car," "boat," "motorcycle." The combo box displays these three options. If I set the property Limit to List to NO, I can manually add other options in both the field and the controls. I do not edit the list; I only write other values manually.
According to Microsoft's documentation on the "Show Only Values of Row Source" property (link below), choosing YES would only let me see "car," "boat," "motorcycle" in the dropdown. If I choose NO, I should see the manually entered words in the dropdown. But that never happens. I always see only the list origin.
No matter what I do, whether I choose a list of values or a table field as the source, I can't get any differences between YES/NO. So I don't know what this property actually does. Does it really do anything? I need a very specific context, maybe adjusting another property as well, I don't know.

 

[The_Doc_Man]

I found a discussion of this property - which I must admit was unfamiliar to me. There is perhaps a reason for that. It is only for Multi-Value Fields (MVF) which is a feature I never use myself. Here is the link to the article that pointed this out. The object-property description is inadequate. TOTALLY inadequate. Therefore, I understand your confusion. I think I will report that description as being a fraction of an angstrom above useless.

Hello Everyone, I am unable to figure out the difference between ComboBox LimitToList property and ShowOnlyRowSourceValues property in Microsoft Access. - Microsoft Q&A

I mean, Is it not true that only what's in the Row Source can be seen in the List? How can you make display something that's not in the Row Source? Thanks for your assistance in advance!

learn.microsoft.com

 

[Misionero]

I found a discussion of this property - which I must admit was unfamiliar to me. There is perhaps a reason for that. It is only for Multi-Value Fields (MVF) which is a feature I never use myself. Here is the link to the article that pointed this out. The object-property description is inadequate. TOTALLY inadequate. Therefore, I understand your confusion. I think I will report that description as being a fraction of an angstrom above useless.

24Hours fighting with this. With microsoft help, Chatgpt, DB's Teachers.... And here, you, in few minutes give the right answer... You have my personal admiration.... Thanks a lot SuperBOSS.

 

[Pat Hartman]

Google isn't smart enough to replace people yet. It is mind boggling fast but fast isn't always best.

 

[The_Doc_Man]

I learned this fact a long time ago. Sometimes, regarding Internet research, it is knowing the right question to ask AND where to focus the question.

 

[KitaYama]

Google isn't smart enough to replace people yet. It is mind boggling fast but fast isn't always best.

Not that I doubt Doc's intelligence, but It really depends on what you search and how you pick your keywords.
In my Google search, that page is the first thing brought up:

 

[The_Doc_Man]

Pat is exactly right and used about the same search string I used. If you just ask the right question you can get a pretty good answer.

 

[MajP]

Even more confusing read this property
Post in thread 'Combobox Zombies Puzzle' https://www.access-programmers.co.uk/forums/threads/combobox-zombies-puzzle.302118/post-1597442