Data moving on its own

[candy]

Why is it that my fields are rearranging themselves
everytime I close my table and reopen it? I am very
confused. Do I have too many fields? How can I stop this
from happening?
Thanks!
Candy

 

[John Vinson]

Why is it that my fields are rearranging themselves
everytime I close my table and reopen it? I am very
confused. Do I have too many fields? How can I stop this
from happening?
Thanks!
Candy

You can stop it from having any effect on you by not using table
datasheets for ANY purpose other than debugging. If you want to see
records sorted in a particular order use a Query with a sort; if you
want to see fields laid out in a particular way on the screen, use a
Form.

Are the *records* being reordered? If so, this is normal; a Table is
an unordered "bag" of data and the sequential order of records is
arbitrary. Or are the *fields* being moved around, horizontally on the
datasheet? That would be rather odd!

 

[Candy]

Thanks! It was the fields that were reordering
themselves. I'll use forms from now on.