Report problem

B

Brandon

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?
 
V

Van T. Dinh

"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.
 
B

Brandon

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.
 
V

Van T. Dinh

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..
 
B

Brandon

That fixed most of it, but now there is just a space between the last 2 lines
of detail.
 
V

Van T. Dinh

* 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.
 
B

Brandon

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?
 
V

Van T. Dinh

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.
 
Top