Reorder fields in datasheet view in a form.

[alfranco17]

Hi.

I am using a form to display data from a query in datasheet view. There is one field that stubbornly refuses to stay where I want it after I close the form and reload it, and keeps moving all the way to the right.

* I have tried changing the data source to have the SELECT statement bring fields in the right order.

* I have rearranged the fields in View mode. I save the form, go to Design Mode, and when I go back to View, the field has moved all the way to the right again.

* I have rearranged the order of the fields in design view.

What am I missing? In the past, I have remade the form from a blank form dragging one field at a time, but I think there must be a better way.

Thanks for your help!

Armando.

 

[Joe4]

I would just order them the want I want in the Query, and then create the Form based on the Query.
It may be a pain, but it is usually the surest way to get it to work the way you want. It may seem like it will take longer, but if you spend hours trying to "fix" what you currently have, then it really isn't.

 

[Alan13]

Hello,
Use the Tab Index property of the controls on the form to set the display order.

 

[OasisUnknown]

One other thing that you can try is in design view select the form selection and go to the control source.

hit the elipse ... and go into the forms query editor and re arrange the query their and save it.

good luck.

 

[OasisUnknown]

@Alan13,

The tab index is to control which fields get access in order when you hit the tab key.

IE select the field for first name (tab index 1) and then hit tab it moves to last name (tab index 2)

rather than hitting tab and it goes to the next created text field which may be somewhere not where you expect it to go.

 

[Micron]

I save the form, go to Design Mode and do what?
I have rearranged the fields in View mode Which mode is that? AFAIK, there are form, datasheet, layout and design views, but no "view mode" per se.

If you drag the fields to where you want them in datasheet view then close the form, it should remain that way next time you open it. Works that way for me.