Conservative. Idaho. Software engineer. Historian. Trying to prevent Idiocracy from becoming a documentary.
Email complaints/requests about copyright infringement to clayton @ claytoncramer.com. Reminder: the last copyright troll that bothered me went bankrupt.
"And we know that all things work together for good to them that love God, to them who are the called according to his purpose." -- Rom. 8:28
Pages
▼
Wednesday, March 16, 2022
I Know There Are Access Experts Out There
One of the columns in the datasheet view has inexplicably moved from column 20 or so to column 2. I want it back in column 20. I would expect column number to be a property of the column. But where is that property?
You can rearrange Access column position by selecting, then drag/drop. You may have accidently done that to cause the current configuration and can deliberately do it to get the wayward column back where you want it.
I do believe that the column order in the dataset view is determined by the order of the SQL statement. Check the SQL view.
ReplyDeleteSQL View? The table has a design view but not an SQL View. This is not a query.
DeleteYou can rearrange Access column position by selecting, then drag/drop. You may have accidently done that to cause the current configuration and can deliberately do it to get the wayward column back where you want it.
ReplyDeleteThis comment has been removed by the author.
DeleteWeird. I reopened it and everything is where it was before.
ReplyDelete