If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Continuous Form Footer is very far away?
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 |
#2
|
|||
|
|||
Continuous Form Footer is very far away?
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" wrote in message ... 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 |
#3
|
|||
|
|||
Continuous Form Footer is very far away?
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. "Bob Larson" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|