Solved Showing values from a multiple selection combo box

[Tophan]

Hi,

I have created a form which includes a multi-selection combo box. Is it possible to show each selection on a different line in the field of the report as opposed to separated by a comma?

 

[Gasman]

Replace , with carriage return?

 

[Uncle Gizmo]

I think you mean a multi Value field?

If so, take a look at Takeshi's video hosted on my blog 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

 

[June7]

A multi-select combobox is only possible with a multi-value field.

Multi-value field is really just links to a hidden table where each item is a record. Showing each item on a separate row requires query that expand the multi-value field.
Using Lookup and multivalued fields in queries (microsoft.com)

Alternatively, build a normal related table and save each item to a record via form/subform arrangement.

 

[Tophan]

Thank you for your suggestions. I actually just found the solution myself in the property sheet - I just changed the Separator Characters from "system separator" which by default is a comma, to "New Line"

 

[June7]

Okay, that's new to me. However, I thought you meant each item should be displayed as a separate record, not just a new line in same field.

This is a just a display formatting - field in table still shows comma between each item.

I have never used multi-value field in distributed db.

 

[Uncle Gizmo]

However, I thought you meant each item should be displayed as a separate record

That's what I thought....