How do I move a field to the left or right

Dan Roach 0 Reputation points
2026-11-10T20:15:12.2666667+00:00

I want a field to be in a different place from left to right. How do I move it.

Microsoft 365 and Office | Access | For home | Windows

3 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-11-10T20:16:01.43+00:00

    In Datasheet View, select the field’s column header and drag the entire column left or right to the position you want.

    1. Open the table or query in Datasheet View.
    2. Click the column header (the field name) to select the whole column.
    3. Drag the header left or right.
    4. Release the mouse button when the insertion marker is at the desired position. To move several adjacent columns together, hold Shift while selecting them, and then drag the group.^1^
    5. Close the table or query and click Yes when Access asks whether to save the layout changes. The new column arrangement will then be used the next time you open that datasheet.^1^

    This changes the display order in Datasheet View, not the underlying field order in the table’s Design View.^2^

    References

    1. Working with datasheets | Microsoft Support
    2. Create a table and add fields | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Chris-D 2,700 Reputation points Independent Advisor
    2026-11-10T20:55:07.1733333+00:00

    Hi Dan,

    To move a field from the left to the right in Microsoft Access, you can follow the steps that match where you are working:

    • In a table: Open the table in Datasheet View, select the field’s column header, and drag it to the desired position.
    • In a form or report: Open it in Layout View or Design View, select the field, and drag it to the desired location. You can also use the arrow keys for more precise positioning.
    • If the field and its label move together, select only the individual control that you want to reposition before dragging it.

    After moving the field, save your changes.

    If you are unable to move it, let me know whether you are working in a table, form, or report and describe what happens when you try.

    For additional guidance, you may find these articles helpful:

    I hope this information is helpful. Should you have any further questions or need additional assistance, please feel free to share them in the comment below. I'm very happy to help.  

    If the answer is helpful, please click 'Yes' and kindly upvote it.

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments
  3. Duane Hookom 27,030 Reputation points Volunteer Moderator
    2026-11-10T23:18:00.8533333+00:00

    Typically it shouldn’t make a difference in a table since table datasheet views are generally not advised. Data is generally displayed in forms where you can move the controls to whatever location you desire. Queries can also easily be designed to show fields in a particular order.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.