Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Access 2010 Continuous Web Forms that are created with Overlapping Windows display only one record at a time and cannot be resized


View products that this article applies to.

Symptoms

In Microsoft Access 2010, when you create a Continuous Web Form that has Overlapping Windows, the form displays only one record at a time, and the form cannot be resized.

↑ Back to the top


Cause

This behavior is by design. By default, Web Forms are created with�BorderStyle set to Dialog. The BorderStyle cannot be changed on a Web Form.

↑ Back to the top


Workaround

To work around this problem, use one of the following methods.

Method 1: Change from Overlapping Windows to Tabbed Windows

  1. On the�File menu, click Options.
  2. Click�Current Database in the navigation page (left pane), select the Tabbed Documents option in the Document Window Options area, and then click OK.

Method 2: Use VBA to increase the InsideHeight property of the form

  1. Open the Microsoft Visual Basic Editor. To do this, use the Ctrl+G keyboard shortcut.
  2. In the Immediate Window, type the following syntax, and then press ENTER:
    forms("<form name>").InsideHeight = 2 * forms("<form name>").InsideHeight
    Note When you apply this change, the form's height is doubled.

↑ Back to the top


More information

Steps to reproduce the behavior
  1. Start Access 2010.
  2. Create a Blank web database.
  3. On the File menu, click Options.
  4. In the�Access Options dialog box, select Current Database , and then click to select the Overlapping Windows check box. Click OK.
  5. Close and reopen the database.
  6. Create a table that has four rows of data.
  7. Save and close the table.
  8. From the�Create tab on the ribbon, click Multiple Items from the Forms group that is based on the table.
Notice that a continuous form is created. But the form only displays one record at a time, and the form cannot be resized.

↑ Back to the top


Keywords: KB2075818

↑ Back to the top

Article Info
Article ID : 2075818
Revision : 3
Created on : 8/25/2011
Published on : 8/25/2011
Exists online : False
Views : 497