Question column sort option greyed out (1 Viewer)

ramblon

Registered User.
Local time
Today, 14:35
Joined
Oct 27, 2019
Messages
23
Hi, trying to sort a column in a datasheet but Sort A-Z, Sort Z-A are greyed out how do I enable sorting on this column?

Thanks for any help
 

isladogs

MVP / VIP
Local time
Today, 12:35
Joined
Jan 14, 2017
Messages
18,210
In the form property sheet, change Record Locks from All Records to No Locks or Edited Record
 

ramblon

Registered User.
Local time
Today, 14:35
Joined
Oct 27, 2019
Messages
23
Excuse my ignorance but how do I open the "form property sheet".
I've gone to the datasheet Design view where there's alot of properties but don't see anything referring to Record locks.
I'm using Access 2016
 

isladogs

MVP / VIP
Local time
Today, 12:35
Joined
Jan 14, 2017
Messages
18,210
Almost the same place as the orientation property in your previous thread but this time in the Data tab.
You can do this in design view or datasheet view
 

Attachments

  • Capture.PNG
    Capture.PNG
    67.3 KB · Views: 680

ramblon

Registered User.
Local time
Today, 14:35
Joined
Oct 27, 2019
Messages
23
How do I add Datasheet to the top ribbon - right of Database Tools?
 

isladogs

MVP / VIP
Local time
Today, 12:35
Joined
Jan 14, 2017
Messages
18,210
You don't. It appears automatically when in datasheet view.
But as already stated you can also do this in design view
 

ramblon

Registered User.
Local time
Today, 14:35
Joined
Oct 27, 2019
Messages
23
This is my datasheet view - no datasheet in the ribbon!
 

Attachments

  • datasheet-view.jpg
    datasheet-view.jpg
    96.2 KB · Views: 123

isladogs

MVP / VIP
Local time
Today, 12:35
Joined
Jan 14, 2017
Messages
18,210
You are looking at the table itself, not a form in datasheet view
 

GinaWhipp

AWF VIP
Local time
Today, 07:35
Joined
Jun 21, 2011
Messages
5,900
Hmm, wondering why you would do this in a Table. The more appropriate place would be in a query. You really don't want your Users in the Table.
 

Users who are viewing this thread

Top Bottom