How do I move a field to the left or right

If you want to move and freeze columns, check out Colin’s amazing samples at https://isladogs.co.uk/. The right side of his page has links for columns.

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.

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:

• Add a field to a form or report
• Add a text box control to a form or report
• Add controls to customize an object

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.