Adding "ALL" in Combo Box

[wraperera]

Good-day all,

I am new to Access DB and trying to figure out how to add a "All" button into a combo box where when it clicks it selects all the colors and when its "All" isn't selected it will let me select other options. The issue is when I try to insert "All" in combo box it doesn't actually select all the color, instead it checks the all button but nothing more than that.


Any help is much much appreciated.

 

[theDBguy]

Hi. Welcome to AWF!

Since you are using a multi value field (MVF), you will need some code to get what you want.

 

[Uncle Gizmo]

Since you are using a multi value field (MVF),

Oops!

 

[Uncle Gizmo]

Regarding multivalue fields. There is an excellent video by:- Takeshi K here:-

Access2010 MultiValued ComboBox​

Not sure it covers what you want, but it is pretty comprehensive I recall.

 

[Uncle Gizmo]

There's some excellent links about multi value Fields on my website here:-

Multi Value Fields Links - Nifty Access

Multi Value Fields Links Consider a scene at a Microsoft office where an innovative individual, perhaps from the marketing team, suggests, "MS Access requires 'Multivalued Fields' 💡 - our aim is to simplify the usage of MS Access for individuals!" Envision the developers emphatically voicing...

www.niftyaccess.com

One of the links points to a previous post where I note that MapJ posted some code examples (which I haven't looked at myself) but may well be worth investigating.

See this thread here:-

Solved - How to identify "selected" items from multivalue combobox

Hi, At the risk of getting yelled at for asking a multivalue combobox question, I would still like to know, how does one cycle through a multivalue combobox to obtain only the records which were selected? Combobox is called NamesList I am using the following without success. For Each oItem In...

www.access-programmers.co.uk

 

[Uncle Gizmo]

By the way, one of the links for multivalue Fields is to one of our members, Colin (Isladog) excellent blog on why you should not use Multi value Fields! See here for more details:-

Multivalued Fields - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk