Continuous Form Footer is very far away?

[carriey]

I am sure that the answer to this is so obvious I'm going to kick myself when
I find out! I have a continuous form that is pulling a number of counts from
a crosstab query. Technically, if over the year additional categories are
added (entirely possible), the form may grow a little bit.

I have some Sums in the Footer but the only problem is that when you open
the form, there is a bunch of white space at the bottom of the form and I
have to scroll way down to see the footer. I would like it to be visible
right after the last row of Detail data. There is no extra space in the
Design View and I have tried closing out and opening the form again but that
doesn't change the location of the footer.

Thanks in advance

 

[Bob Larson]

Carriey:

A Form FOOTER is just that. It falls at the FOOT of the form and doesn't
appear else where. If you've already removed all of the detail space right
up to the controls in the form, it won't get any higher.

Bob Larson
Microsoft Access MVP
Administrator, Access World Forums

 

[carriey]

Thanks Bob. I know in a Single Form your footer will appear below the
detail.

Because this is a Continuous Form there is only row in the detail which of
course repeats on the form as many times as needed. The footer is directly
below that one detail row and is also only one row.

I was hoping there was perhaps a way with code or changing a property to say
"show the footer right after the detail" as users are not going to like
scrolling all the way down to see the totals.