Form design

Resolved · Medium Priority · Version 2007

Tue 25 Jan 2011, 15:51 Delegate Doireann said...

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.

Mon 31 Jan 2011, 10:37 Trainer Andrew said...

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

Tue 1 Feb 2011, 14:19 Trainer Anthony said...

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

Tue 8 Feb 2011: Automatically marked as resolved.

Training courses