Microsoft KB Archive/926957

= The field order in a form differs from the field order in a record source in Access 2007 =

Article ID: 926957

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-





SYMPTOMS
In Microsoft Office Access 2007, when you drag fields to a form, the field order in the form differs from the field order in the record source. This issue occurs if the following conditions are true:
 * You drag the fields from a table in the record source.
 * You drag the fields to the form in Layout view.



CAUSE
This issue occurs because the order in which fields appear in a table in a record source is not related to the order in which Access 2007 returns the fields.



Steps to reproduce the problem

 * 1) Open a database in Access 2007.
 * 2) Close all open objects.
 * 3) On the Create tab, click Blank Form in the Forms group.

The form opens in Layout view. And, blank field list appears on the form.
 * 1) Press ALT+ENTER to open the property sheet of the form.
 * 2) Click the Employees table for the record source.
 * 3) On the Formatting tab, click Add Existing Fields in the Controls group.
 * 4) Examine the order of the fields in the Field list. This order should match the order of the fields in the table.
 * 5) Select all the fields, and then drag all the fields to the Layout form grid.
 * 6) Examine the order of the fields in the Layout form grid. Then, compare this order to the order of the fields in the table.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbbug kbprb kbexpertiseinter KB926957

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.