Why can't I sort on the Column?

A2003
Datasheet view form bound to a table. First column is bound to primary key
ID and I cannot sort by it (context menu is greyed-out for
Ascending/Descending), Why? I can open the table and sort on that ID column,
but not in the form. In the form all other columns are sort-able.
what's going on?

check that the form's properties:
Allow Additions
Allow Edits
Allow Deletions

set to 'no' ?? may be cause

"bhammer" wrote:

A2003
Datasheet view form bound to a table. First column is bound to primary key
ID and I cannot sort by it (context menu is greyed-out for
Ascending/Descending), Why? I can open the table and sort on that ID column,
but not in the form. In the form all other columns are sort-able.
what's going on?

No, that's not it. I have:

AllowEdits— Yes
AllowDeletions— Yes
AllowAdditions— Yes
DataEntry— No

Strange. I read in Help that calculated fields and memo fields cannot be
sorted on. But this a plain old ID field. . .

I found it--the stinkin' Tab property! I had it set to No because I wanted
the focus to go the next column on open. Well, who knew that with Tab set to
No it also disables the ability to Sort by that column.

You cannot sort on a field whose Tab property is set to No.

Go figure. . .
-bhammer

"bhammer" wrote:

No, that's not it. I have:

AllowEdits— Yes
AllowDeletions— Yes
AllowAdditions— Yes
DataEntry— No

Strange. I read in Help that calculated fields and memo fields cannot be
sorted on. But this a plain old ID field. . .

wow - I had no idea....thanks for posting your solution as I'll remember next
time...

"bhammer" wrote:

I found it--the stinkin' Tab property! I had it set to No because I wanted
the focus to go the next column on open. Well, who knew that with Tab set to
No it also disables the ability to Sort by that column.

You cannot sort on a field whose Tab property is set to No.

Go figure. . .
-bhammer

"bhammer" wrote:

No, that's not it. I have:

AllowEdits— Yes
AllowDeletions— Yes
AllowAdditions— Yes
DataEntry— No

Strange. I read in Help that calculated fields and memo fields cannot be
sorted on. But this a plain old ID field. . .

"bhammer" wrote in message
...
I found it--the stinkin' Tab property! I had it set to No because I wanted
the focus to go the next column on open. Well, who knew that with Tab set
to
No it also disables the ability to Sort by that column.

You cannot sort on a field whose Tab property is set to No.


I am not able to reproduce this. When you say "Tab property", do you mean
"Tab Stop property"? There is no "Tab" property. But I took a datasheet
form, changed the Tab Stop property of the text box bound to the table's
autonumber primary key, and was able to sort on that field with no problem.
Maybe I am misunderstanding you, or maybe there's some additional
contributing factor. Is there anything else unusual about your form at all?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Dirk,

Nothing unusual about the table or form that I can see.

I was able to reproduce it using a different table with only two fields; I
used the Form Wizard to make a form based on the table; I changed the Tab
Stop property of the textbox bound to the autonumber ID field to 'No' (all
other properties are defaults); then changed the view to Datasheet; right
clicked on the ID textbox to get the default context menu--and BAM--the two
Sort commands are greyed-out. In Form View they are NOT greyed out.

Apparently this only has to do with the Form Datasheet view. Also maybe
specific to Access 2003 with mdb's in Access 2000 format. That's I'm using.
WinXP.

Strange one!

-Brad

"bhammer" wrote in message
...
Dirk,

Nothing unusual about the table or form that I can see.

I was able to reproduce it using a different table with only two fields; I
used the Form Wizard to make a form based on the table; I changed the Tab
Stop property of the textbox bound to the autonumber ID field to 'No' (all
other properties are defaults); then changed the view to Datasheet; right
clicked on the ID textbox to get the default context menu--and BAM--the
two
Sort commands are greyed-out. In Form View they are NOT greyed out.

Apparently this only has to do with the Form Datasheet view. Also maybe
specific to Access 2003 with mdb's in Access 2000 format. That's I'm
using.
WinXP.

Strange one!

Interesting. I still can't reproduce it, even following your steps as best
I can. I'm using Access 2003 SP3, and the database I'm testing with is in
Access 2000 format. Do you have all service packs applied? Im running
under Vista, not XP, but I don't think that's likely to be the reason for
the difference.

If you'd like to send me a sample database to examine, you can get my real
e-mail address from my website, which is listed in my sig below.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

plz post your results.

I have a form in Access02/XP where the sort is greyed out. I haven't been
able to figure out why.



"Dirk Goldgar" wrote:

"bhammer" wrote in message
...
Dirk,

Nothing unusual about the table or form that I can see.

I was able to reproduce it using a different table with only two fields; I
used the Form Wizard to make a form based on the table; I changed the Tab
Stop property of the textbox bound to the autonumber ID field to 'No' (all
other properties are defaults); then changed the view to Datasheet; right
clicked on the ID textbox to get the default context menu--and BAM--the
two
Sort commands are greyed-out. In Form View they are NOT greyed out.

Apparently this only has to do with the Form Datasheet view. Also maybe
specific to Access 2003 with mdb's in Access 2000 format. That's I'm
using.
WinXP.

Strange one!

Interesting. I still can't reproduce it, even following your steps as best
I can. I'm using Access 2003 SP3, and the database I'm testing with is in
Access 2000 format. Do you have all service packs applied? Im running
under Vista, not XP, but I don't think that's likely to be the reason for
the difference.

If you'd like to send me a sample database to examine, you can get my real
e-mail address from my website, which is listed in my sig below.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Dirk, GBA,

I sent a test mdb to Dirk's email per your request.

I started from scratch with new mdb in Access 2003 SP3 (11.8204.8221) under
WindowsXP SP3 Build 2600 version 5.1.2600. I made one table in design view
with two fields: ID (Autonumber), and (Field Text). Then using the Make Form
Wizard, selected the table and all fields. Then the only thing I changed in
the form design was the Tab Stop property on the Other tab. Changed it from
default Yes, to No. All others props are default. In Form View the Sort
commands are enabled on the ID field's context menu, but with the form in
Datasheet view, the sort commands are disabled (grayed-out). Same as before.