Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Brightup, Earl
  New Posts New Posts RSS Feed - Optimizing Continuous Form Size
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

Optimizing Continuous Form Size

 Post Reply Post Reply
Earl Brightup View Drop Down

Joined: 24 Jun 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Earl Brightup Quote  Post ReplyReply Direct Link To This Post Topic: Optimizing Continuous Form Size
    Posted: 23 Jul 2012 at 6:42am

A "Continuous Form" is one of the form types that can be generated by Microsoft Access.  It can display a variable number of rows of data with a fixed number of columns.  This type of form is often used for displaying a list of items with related information such as Item Number, Item Description, Item Price, etc.  Data fields are displayed in a format similar to a spreadsheet table.


This document describes a method of dynamically optimizing the vertical size of a Continuous Form to fit the number of rows of data to be displayed—on any screen size and resolution.  For continuous forms that do not fill the Access window top to bottom, a method of vertically positioning them is suggested.


Dynamically adjusting the size of continuous forms can be valuable, especially in Access applications that will be distributed to a number of locations having different screen sizes and different screen resolutions.


The sample Access database to which this document refers ("Optimizing Continuous Form Size.mdb") was developed using Access 2003 in Access 2000 file format, and has been tested successfully under Access 2000, 2003, and 2007.  A bit of the code has run under Access 2010.

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.