By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,572 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,572 IT Pros & Developers. It's quick & easy.

Report formatting

P: n/a
I am having problems formatting an Access 2003 report which is trivial
in the extreme (tabular layout, 9 fields from 1 table per row in the
detail section, no groups/totals).

One field (only) in the row can be longer than its text-box on rare
occasions, so I've made the text-box and detail section CanGrow
properties = Yes. This has had one positive effect - the occasional
long field now displays correctly, split over 2 rows - but also a very
negative effect - the majority short values in that field are also
split over 2 rows when they were happily fitting in a single row
before the property change, and even where the field is null the row
takes up twice the vertical space it did before.

In summary, a 24-page report has now become 43 pages.

Any ideas what could be wrong, or is this a 'facility'? ;-)

Dave

Aug 8 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Wed, 08 Aug 2007 09:40:56 -0700, D.*****@ed.ac.uk wrote:
I am having problems formatting an Access 2003 report which is trivial
in the extreme (tabular layout, 9 fields from 1 table per row in the
detail section, no groups/totals).

One field (only) in the row can be longer than its text-box on rare
occasions, so I've made the text-box and detail section CanGrow
properties = Yes. This has had one positive effect - the occasional
long field now displays correctly, split over 2 rows - but also a very
negative effect - the majority short values in that field are also
split over 2 rows when they were happily fitting in a single row
before the property change, and even where the field is null the row
takes up twice the vertical space it did before.

In summary, a 24-page report has now become 43 pages.

Any ideas what could be wrong, or is this a 'facility'? ;-)

Dave
I'm not sure I understand what you would like to happen.
If the control grows, where would you expect it to grow to?
It has to go down. If it goes down, the next record is also moved down
proportionately. .
Perhaps you would be satisfied by moving this one control to the end
of your record's data, so that the other controls (for that record)
precede this one. They will all appear on the same line and just this
one control will grow.
The next record will be moved downward from the end of the can grow
control.
If I've miss-understood you, please post back.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 8 '07 #2

P: n/a
Have you got all the controls and section set to CanGrow, and most
importantly CanShrink set to YES?

Phil
"fredg" <fg******@example.invalidwrote in message
news:1e******************************@40tude.net.. .
On Wed, 08 Aug 2007 09:40:56 -0700, D.*****@ed.ac.uk wrote:
>I am having problems formatting an Access 2003 report which is trivial
in the extreme (tabular layout, 9 fields from 1 table per row in the
detail section, no groups/totals).

One field (only) in the row can be longer than its text-box on rare
occasions, so I've made the text-box and detail section CanGrow
properties = Yes. This has had one positive effect - the occasional
long field now displays correctly, split over 2 rows - but also a very
negative effect - the majority short values in that field are also
split over 2 rows when they were happily fitting in a single row
before the property change, and even where the field is null the row
takes up twice the vertical space it did before.

In summary, a 24-page report has now become 43 pages.

Any ideas what could be wrong, or is this a 'facility'? ;-)

Dave

I'm not sure I understand what you would like to happen.
If the control grows, where would you expect it to grow to?
It has to go down. If it goes down, the next record is also moved down
proportionately. .
Perhaps you would be satisfied by moving this one control to the end
of your record's data, so that the other controls (for that record)
precede this one. They will all appear on the same line and just this
one control will grow.
The next record will be moved downward from the end of the can grow
control.
If I've miss-understood you, please post back.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Aug 8 '07 #3

P: n/a
Phil, I have checked all the controls and the detail section now have
both CanGrow and CanShrink set to 'Yes', but the problem remains the
same.

fredg: what you describe is exactly what I have already! i.e. the
detail section has the 9 text-boxes in a line across the page, and
only the last one is ever expected to contain more data than will fit
on one row. So before adding CanGrow=Yes the report looked like:

...................<other fields>.................ABC123 Short value
...................<other fields>.................XYZ789 Long value
too wide to display complet

and after the change I get:

...................<other fields>.................ABC123 Short

value

...................<other fields>.................XYZ789 Long value
too wide to display

completely

With CanGrow and CanShrink set to Yes on everything, I wouldn't expect
the first row to spread over two lines.

Dave
On Aug 8, 9:56 pm, "Phil Stanton" <p...@stantonfamily.co.ukwrote:
Have you got all the controls and section set to CanGrow, and most
importantly CanShrink set to YES?

Phil

"fredg" <fgutk...@example.invalidwrote in message

news:1e******************************@40tude.net.. .
On Wed, 08 Aug 2007 09:40:56 -0700, D.St...@ed.ac.uk wrote:
I am having problems formatting an Access 2003 report which is trivial
in the extreme (tabular layout, 9 fields from 1 table per row in the
detail section, no groups/totals).
One field (only) in the row can be longer than its text-box on rare
occasions, so I've made the text-box and detail section CanGrow
properties = Yes. This has had one positive effect - the occasional
long field now displays correctly, split over 2 rows - but also a very
negative effect - the majority short values in that field are also
split over 2 rows when they were happily fitting in a single row
before the property change, and even where the field is null the row
takes up twice the vertical space it did before.
In summary, a 24-page report has now become 43 pages.
Any ideas what could be wrong, or is this a 'facility'? ;-)
Dave
I'm not sure I understand what you would like to happen.
If the control grows, where would you expect it to grow to?
It has to go down. If it goes down, the next record is also moved down
proportionately. .
Perhaps you would be satisfied by moving this one control to the end
of your record's data, so that the other controls (for that record)
precede this one. They will all appear on the same line and just this
one control will grow.
The next record will be moved downward from the end of the can grow
control.
If I've miss-understood you, please post back.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Aug 9 '07 #4

P: n/a
On Thu, 09 Aug 2007 03:23:22 -0700, D.*****@ed.ac.uk wrote:
Phil, I have checked all the controls and the detail section now have
both CanGrow and CanShrink set to 'Yes', but the problem remains the
same.

fredg: what you describe is exactly what I have already! i.e. the
detail section has the 9 text-boxes in a line across the page, and
only the last one is ever expected to contain more data than will fit
on one row. So before adding CanGrow=Yes the report looked like:

..................<other fields>.................ABC123 Short value
..................<other fields>.................XYZ789 Long value
too wide to display complet

and after the change I get:

..................<other fields>.................ABC123 Short

value

..................<other fields>.................XYZ789 Long value
too wide to display

completely

With CanGrow and CanShrink set to Yes on everything, I wouldn't expect
the first row to spread over two lines.

Dave

On Aug 8, 9:56 pm, "Phil Stanton" <p...@stantonfamily.co.ukwrote:
>Have you got all the controls and section set to CanGrow, and most
importantly CanShrink set to YES?

Phil

"fredg" <fgutk...@example.invalidwrote in message

news:1e******************************@40tude.net. ..
>>On Wed, 08 Aug 2007 09:40:56 -0700, D.St...@ed.ac.uk wrote:
>>>I am having problems formatting an Access 2003 report which is trivial
in the extreme (tabular layout, 9 fields from 1 table per row in the
detail section, no groups/totals).
>>>One field (only) in the row can be longer than its text-box on rare
occasions, so I've made the text-box and detail section CanGrow
properties = Yes. This has had one positive effect - the occasional
long field now displays correctly, split over 2 rows - but also a very
negative effect - the majority short values in that field are also
split over 2 rows when they were happily fitting in a single row
before the property change, and even where the field is null the row
takes up twice the vertical space it did before.
>>>In summary, a 24-page report has now become 43 pages.
>>>Any ideas what could be wrong, or is this a 'facility'? ;-)
>>>Dave
>>I'm not sure I understand what you would like to happen.
If the control grows, where would you expect it to grow to?
It has to go down. If it goes down, the next record is also moved down
proportionately. .
Perhaps you would be satisfied by moving this one control to the end
of your record's data, so that the other controls (for that record)
precede this one. They will all appear on the same line and just this
one control will grow.
The next record will be moved downward from the end of the can grow
control.
If I've miss-understood you, please post back.
>>--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Can Shrink for sure is not suitable here as it doesn't work if you
have another control on the same line.

Is it possible that the right margin of the report is causing even
what you believe to be a short value to grow? Perhaps the report just
needs a touch less right margin.
How about playing with the control's margins as well?
I get it sometimes when printing labels, The text seems to fit
properly until the last column and you'll get a "Some data may not be
displayed ..." message, even though it prints OK after you close the
message box. It's the empty space on the label.

Good luck.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 9 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.