How do you move fields in a datasheet form? - Access 2013

[LovellDC]

I have just created a database for the first time and created a form by using Create, More Forms, Datasheet and want to change the fields. Although I can move the fields in datasheet view and save it when I close the form and reopen the fields have moved back to where they were. I do have combo lists in the fields not sure if this should make any difference?

The reason I have created a datasheet form is because the users will have to copy and paste data from an exel spreadsheet so thought the datasheet form (although doesn't look very professional) would be the quickest way of pasting columns of data in one go into the form, I am happy to accept any better suggestions as well as the answer to my question.

By the way I only have one table (imported from Excel). I tried the wizard to create tables hoping to add relationships but ended up with about 13 and didn't know how to edit them! This one table at the moment answers my queries.

Can any one help please?

Thanks

[ranman256]

In form design ,move the field to the order you want, save.

[LovellDC]

Thank you this works fine but I want to move the fields in the datasheet view as this is where the users will copy and paste data from a spreadsheet, as this would be quicker than form view.

Can you still help?

[orange]

LovellDC,

You may want to review options for such activity (moving data from Excel to Access) in this article by M$oft.

Good luck.

[NTC]

256's post gives how to arrange fields as the designer - but datasheet feature allows users to drag them and rearrange just like excel - so not sure what it is you seek.

[ranman256]

The form can be set to data sheet.

[LovellDC]

Thanks everyone

[Missinglinq]

When you create a Datasheet View Form, using the Form Wizard, Access arranges the Columns as the appear in the underlying Table. Going into Form Design View and re-arranging them doesn't work...they remain in the order that they are in the Table.

But you can, in VBA, change the order of display, using this kind of thing:

Private Sub Form_Load()
 Me.EmployeeID.ColumnOrder = 1
 Me.EmployeeName.ColumnOrder = 2
End Sub

Linq ;0)>

[CJ_London]

column order is originally defined by the form recordset

SELECT * - the order per the table

SELECT Fld3, fld2, fld9, fld1 - the order as listed in the select statement