Change layout of subreport (XP)

Topic

New Reply

I have a very simple issue… but darned if I can get it to work!

on a subreport are two fields… LegID which is not visible, it simply links the parent/child… and the field tablenumber. for each legID, there are potentially several TableNumbers. I want the format of the output of this field to be a comma’d list reading from left to right, rather than the normal list output.

for example…

13
14
9
7
should read as 13,14,9,7

Thanks for any help you can give… Jenn

Reply | Quote

Replies

The attachment to post 301,393 contains the code for a function named Concat that you can use to concatenate values into one long string. Copy the function into a standard module. You can then use it in expressions in queries and in the control source of text boxes on forms/reports.

In your case, you’d put a text box in the detail section of the report with a control source like this:

=Concat(“NameOfTable”,”TableNumber”,”LegID = ” & [LegID])

where NameOfTable is the name of the table (or query) that contains LegID and TableNumber.

Note: make sure that the text box is NOT named TableNumber, for that would confuse Access.

Reply | Quote

Worked like a charm! Thank you

Reply | Quote