change the order of columns in form

[DAPPLE]

I want to change the order of the columns in the datasheet view of a form because the tab won't jump evenly from cell to cell. This is probably due to the fact that I rearranged the order of the fields in the form view.
Could someone offer me a simple solution, I sure would appreciate it.

 

[cindyareed]

When you are in design mode on your form click on the view button. You will see TAB ORDER in the drop down box. click on it then you can put the fields in the order you want user to enter data in.

Cindy

 

[DAPPLE]

Thank you Cindy.. one more thing though. What about the order you tab through the fields on the Form View. That didn't change with the order of the columns.

 

[Jack Cowley]

In Normal view click on a column. When it is highlighted click and drag it where you want.