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

Tophan

Registered User.
Local time
Today, 02:32
Joined
Mar 27, 2011
Messages
326
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, 07:32
Joined
Sep 21, 2011
Messages
10,555
Replace , with carriage return?
 

June7

AWF VIP
Local time
Yesterday, 22:32
Joined
Mar 9, 2014
Messages
4,381
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, 02:32
Joined
Mar 27, 2011
Messages
326
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, 22:32
Joined
Mar 9, 2014
Messages
4,381
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