Multivalued Combobox Arrangement

[whojstall11]

I have a multivalued combobox that I want to rearrange to so it look like an table example:

This what my combobox look like in a report:







I want my combobox to look like this:


Any suggestions?

[rpeare]

Don't use multi value fields, they are a horrible, horrible, horrible addition to access and cause no end of grief. Apart from that I don't see any difference between the two, they are both in the same order.

I would really strongly suggest you try a more normalized structure to store these values.

[whojstall11]

I need it to look like this:


But I couldnt figure out how to have multiple entries for a combobox without the Multivalued selection active. How would I go about normalizing that?

[June7]

I agree with rpeare, multi-value fields may seem like a convenience but they can be tricky to work with. However, I doubt what you want will be possible with a conventional structure either. A combobox is meant to list items in the dropdown and the multiple columns are to display fields of each record in the item list, not multiple records side-by-side. And the data stored in field cannot be configured for tabular display.

The multi-value field can be expanded in a query so each element is listed like a separate record, but not multi-columnar. Review: http://office.microsoft.com/en-us/ac...010149297.aspx

[Geo21]

Rearrangement will be done For presentation (report) purposes? If so, you will need to create a table with field1 and field2. Then, divide the number of values with 2, and create a loop that will get the first value to record1, field1 then record2, field1 and so on. When reaching the result from the division, start same loop process with field2.

[June7]

Report has page setup feature to display records in multi-column arrangement. Temp table and code not necessary.