D
David S via AccessMonster.com
I'm trying to modify a set of reports that use lots and lots of subforms. The
one I'm concerned with has a single set of records going down the page - in
Design mode, it looks like:
[period]
[Sales]
[% change]
and when you run it, you get the records going across the page, like so:
1 2 3 4 5
$10 $20 $25 $11 $12
3% 4% 2% 3% 4%
I'm trying to increase the width of the fields to spread them out a bit more -
except when I increase the width of the fields, they get truncated, like so:
1 2 3 4 5
$1 $2 $2 $1 $1
3 4 2 3 4
It's one of those partial truncations where you can actually see half of the
character that's been chopped in half. If I increase the size of the report,
I just get more of the field disappearing, as I think there's less to fit on
the page.
So, my first question is how does the report get the records to go across the
page like this? I suspect that there's some width somewhere that it avcting
as an absolute max for each record, so when I increase the width of the
indidivual fields, they get bigger but are then cut off by the width defined
for each column. But I can't for the life of me find where this field might
be. Any help much appreciated - thanks!
one I'm concerned with has a single set of records going down the page - in
Design mode, it looks like:
[period]
[Sales]
[% change]
and when you run it, you get the records going across the page, like so:
1 2 3 4 5
$10 $20 $25 $11 $12
3% 4% 2% 3% 4%
I'm trying to increase the width of the fields to spread them out a bit more -
except when I increase the width of the fields, they get truncated, like so:
1 2 3 4 5
$1 $2 $2 $1 $1
3 4 2 3 4
It's one of those partial truncations where you can actually see half of the
character that's been chopped in half. If I increase the size of the report,
I just get more of the field disappearing, as I think there's less to fit on
the page.
So, my first question is how does the report get the records to go across the
page like this? I suspect that there's some width somewhere that it avcting
as an absolute max for each record, so when I increase the width of the
indidivual fields, they get bigger but are then cut off by the width defined
for each column. But I can't for the life of me find where this field might
be. Any help much appreciated - thanks!