Can Shrink Problem on my report

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I have about 100 text fields with the following code in a
report.

IFF([DisplayNone], "Display = None", Null)

The text fields that are not Null show up on the report.
However, my problem is that when you view or print the
report there are still a lot of spaces between some of the
text that prints. Some lines are fine and others have a
large space.

I have the detail section of the report and the properties
section marked off can shrink, can grow and also made sure
there is nothing else touching the text, next to the text,
or in another column.

Can anyone help with this, I have been working on this
report for about 3 months now and do not know what is
wrong.

Thanks,

Denise
 
Denise

If I were faced with this, I'd probably back up and look at the underlying
data and ask why I needed 100 fields. Are many/most of these "repeating"
fields, i.e., of the general form "JanuaryTotal", "FebruaryTotal", ..., or
"FirstItemName", "SecondItemName", ...?

If so, you are running into the problems of trying to use Access as a
spreadsheet.

Please provide more information about the underlying data structure(s) from
which you are drawing for your report.

Also, is there a chance you could use a Detail section in the report to
display multiple rows of information, but only need to use the controls
once, setting the value you mentioned in that single location?

You are certainly patient to keep at it for 3 months -- "persistent" might
not even be a strong enough term!
 
Back
Top