Continuous Form's Footer

[Tony]

Hi All,

I have a form with a continuous sub-form. The sub-form is bound to a query
that at this point will display a variable number of records depending on
what the query returns, based on criteria selected in the main form. So
far, I've only enough data in the tables so that either 4 or 5 records are
returned. The footer has controls that display totals for the records in
the sub-form.

I've noticed that the footer is always positioned such that there is space
for a 5th record, even when the query returns only 4 records. Is there a
property I can set that will dynamically size the sub-form, depending on how
many records are returned, so that the footer controls are immediately under
the sub-form's detail controls? It currently looks something like this:

4 RECORDS RETURNED

ID1 1 2
ID2 2 3
ID3 3 4
ID4 4 5

Totals 10 14


5 RECORDS RETURNED

ID1 1 2
ID2 2 3
ID3 3 4
ID4 4 5
ID5 5 6
Totals 15 20

Thanks for any assistance,

Tony

 

[Randall Arnold]

I don't know about dynamically sizing, but couldn't you just add some
leading space to the footer?

Randall Arnold

 

[TC]

If the query is updatable, and the form's AllowAdditions property is set to
true, perhaps the "space for a 5th record" is in fact, the space for a >new<
record? If so, try setting AllowAdditions to False.

HTH,
TC

 

[Tony]

Hi Randall,

Thanks for the response. The issue is that I already have too much space
between the last record's controls and the footer controls. As you
suggested, I added some space between the top of the footer and the controls
in the footer and it produces the same results. What I need to do is
eliminate the space...

If you have any more suggestions, let 'em fly. I'm going to leave it be for
now and come back to it later.

Thanks for the suggestion,

Tony

 

[Tony]

Hi TC,

The only things I'm allowing on the continuous form are filters and edits.
The only thing I'm allowing on the main form is edits (so criteria on which
to base the subform can be entered). Any other suggestions?

Thanks,

Tony

 

[TC]

Sorry, no :-(

TC

Hi TC,

The only things I'm allowing on the continuous form are filters and edits.
The only thing I'm allowing on the main form is edits (so criteria on which
to base the subform can be entered). Any other suggestions?

Thanks,

Tony

there