Forum Discussion
Office 365 - Access
This may be a bit clearer if you provide a screenshot illustrating the problem.
Are you directly adding records into tables, i.e. not using the appropriate interface object, a form?
When you say the order of the fields changes, that's hard to picture, actually. Unless you deliberate move fields left to right in datasheet view, they do not change, so something tells me you're probably either not providing all the details or saying something in a way that doesn't convey the actual problem.
Oh, it just occurred to me that you don't mean the order of the fields, but the order of the records in the fields. Is that a good guess?
If so, there's a good reason for that, but before we indulge in a lengthy discussion we ought to be clear on what it is we're discussing.
And by the way, 30 fields is above average, but not what normally one would call large. 80 records is tiny, compared to what tables can hold, i.e. hundreds of thousands of records.