Data moving on its own

  • Thread starter Thread starter candy
  • Start date Start date
C

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
 
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
Click to expand...

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!
 
Thanks! It was the fields that were reordering
themselves. I'll use forms from now on.
 
Back
Top