Subform Height Change on Base on REcords

[ootkhopdi]

Hi All

Can i change Subform (DataSheet view) Height based on records showing or any textbox value..

 

[sneuberg]

You can computer the height base on the number of records and height of a textbox and then adjust the height of the subform. I post some code for this type of problem in this thread.

 

[ootkhopdi]

Thanks for giving fast reply
but your database sample not giving me a solution as i can understand

i want to change subform height as containing records..
so please give me stepwise solution

 

[sneuberg]

i want to change subform height as containing records..
so please give me stepwise solution

Do you mean you want the height to adjust as records are added or deleted?

If you can upload you database or a copy with the relevant part I'll see if I can adapt the code to your situation.

 

[ootkhopdi]

My data base containing much records. so sorry i can't upload it

trying to sample it

yes i want to change subform height as records shows in datasheet

 

[sneuberg]

My data base containing much records. so sorry i can't upload it

I might be easier just to create a new database and import the relevant parts. As far as trimming the number of records down you can select multiple records to delete as shown below.