boofpigs
Oct 16 2007, 02:16 AM
Hi,
I am probably missing something really basic but I am trying to create a "table" inside a report. By this I mean that a query is run and the output of this query should go into a table (in the report). I have played around with using borders on the text boxes and using lines around the text boxes but these do not give me the results that I am after. I need the table to expand and contract depending on the length of the string contained.
Any ideas?
Regards,
Andrew
Steve Schapel
Oct 16 2007, 03:32 AM
Andrew,
I am not 100% clear on where you are falling short of what you really want. Generally, a report will produce a table-like structure by default. The Detail section of the report will repeat for each record in the report's record source query. If the amount of data in each record is variable, you can set the Can Grow property of the applicable controls in the report (you do this is Design view of the report), and also the Can Grow property of the report section itself, and the size of each record wil adjust... is that what you mean?