Auto height of subform based on record display

[ootkhopdi]

i have a subform name(SUBSAL)
in this subform i get reocrds for some employee as select combobox Name(CMBEMP)

some employee having 2 record or some having 6 record as their transaction

my problem is that
i have sum of transaction at subform footer field
but when only 2 records shows in subform it shows a major gap or blank space in subform detail section

how can i remove it
pls tell me solution

 

[JHB]

some employee having 2 record or some having 6 record as their transaction

my problem is that
i have sum of transaction at subform footer field
but when only 2 records shows in subform it shows a major gap or blank space in subform detail section

how can i remove it
pls tell me solution

Use a report instead - a form is more steady.

 

[ootkhopdi]

i can use report
but this time i m working on a form which show an employee data for editing

so i want that solution

 

[ootkhopdi]

Please give me solotion

 

[JHB]

Then use some code and calculate the high of the objectframe for the subform, depending of how many records are shown.

 

[Mike375]

You could try something like setting the "height" property of the footer and the "top" property of you your text box that totals the number of transactions and based on the number of records showing in the sub form. Try attaching the code to the OnCurrent event.

Personally I think if you have your "total" moving up and down as you move from record to record it will not look very good and I would find it annoying.

Probably different for a one off print out, that is, a print our an employee's record but then as JHB suggested above that then becomes a report.