Report problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Well, I got Access to hide the lines that don't meet certain criteria, but it
is not shift up the ones that do meet the criteria. For example:
Item 1

Item 3
Item 4


Item 7
How it should be (using this example) is:
Item 1
Item 3
Item 4
Item 7
I know that this is possible, but I don't remember what I need to tell
Access to do. Anyone know?
 
"Can Shrink" Property of the Control?

There may be other problems, e.g. if you have 2 more Controls on the same
horizontal position then "Can Shrink" may not work correctly.

BTW, this question is more appropriate in the Reports newsgroup, not Forms
newsgroup.
 
I have all them set to that now, but it is still not working.

P.S. I didn't realize I was posting for the Forms group until after I hit
Post.
 
If you don't have the other possible problem I mentioned, I guess you should
check the "Can Shrink" Property of the Detail section (which is a Control!)
since I can't see your Report..
 
* Check the "Can Shrink" Property of all Controls.

* Beware of invisible characters at the end of your Text values, e.g. CR
character will created a blank line which means that the Control cannot be
shrinked as you expect.

Try setting border of your TextBoxes (for testing) so that you can see which
Control doesn't shrink.
 
I've done everything I can think of, even recreating the report, but it is
still happening. I have also done as you suggested. Is there any other
advise you can offer?
 
If your database is small, compact and zip and upload to a Web site that
others here can download and post the Web address here.
 
Back
Top