Solved Showing values from a multiple selection combo box (1 Viewer)

Tophan

Registered User.
Local time
Today, 01:44
Joined
Mar 27, 2011
Messages
362
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

Enthusiastic Amateur
Local time
Today, 05:44
Joined
Sep 21, 2011
Messages
14,048
Replace , with carriage return?
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 05:44
Joined
Jul 9, 2003
Messages
16,245
I think you mean a multi Value field?

If so, take a look at Takeshi's video hosted on my blog here:-

 

June7

AWF VIP
Local time
Yesterday, 21:44
Joined
Mar 9, 2014
Messages
5,424
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

Registered User.
Local time
Today, 01:44
Joined
Mar 27, 2011
Messages
362
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

AWF VIP
Local time
Yesterday, 21:44
Joined
Mar 9, 2014
Messages
5,424
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.
 
Last edited:

Users who are viewing this thread

Top Bottom