Multivalue Reports in Reports

[Brian Carlson]

Let me start by stating that I plan to remove the multivalue field and
replacing it with a link to a new table. However, until I able to find the
time to make this design change I nee to formulate a report that contains
this multivalue field. The problem I am running into is that the field is
displayed similiar to the way it is displayed on a form, i.e. a list of
checkboxes, with a scroll bar so you can see all selected values. I do not
see a Can Grow property and am wondering how I can allow this control to grow
to fit the data in it. In addition, for some reason each of these fields
shows the items that have been selected along with an empty check box...any
ideas. Is there a quick fix? If not, I will try to find the time to correct
my design. Thanks in advance.

Brian

 

[Brian Carlson]

Let me start by stating that I plan to remove the multivalue field and
replacing it with a link to a new table. However, until I able to find the
time to make this design change I nee to formulate a report that contains
this multivalue field. The problem I am running into is that the field is
displayed similiar to the way it is displayed on a form, i.e. a list of
checkboxes, with a scroll bar so you can see all selected values. I do not
see a Can Grow property and am wondering how I can allow this control to grow
to fit the data in it. In addition, for some reason each of these fields
shows the items that have been selected along with an empty check box...any
ideas. Is there a quick fix? If not, I will try to find the time to correct
my design. Thanks in advance.

Brian

 

[Allen Browne]

In query design, you can add .Value to the multi-valued field to generate a
record for each value.

Results are read-only, so may not suit a form but should be fine for a
report.