Doireann has attended:
Access Intermediate course
Form design
Database created on earlier Microsoft Access but now being run on 2007. In subform, there is a large gap between last fields and end of form. This does not appear in design view and I cannot see any reason why it is appearing in form view.
RE: Form design
Hi Doireann
I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.
Thank you for your patience.
Kind regards,
Andrew
RE: Form design
Hi Doireann, thanks for your query. In design view, select the subform, and in properties set AutoSize to Yes. Then CLOSE and reopen. If this doesn't work, you'll either need to delete out the subform and rebuild it or use some code:
http://www.eggheadcafe.com/software/aspnet/35609071/automatically-resize-subform-height-based-on-number-of-returned-re.aspx
Hope this helps,
Anthony
