Subform header in Datasheet view

[MacDermott]

I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.

How can I learn this?

TIA
- Turtle

[Allen Browne]

Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...

I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top
of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.

[MacDermott]

Thanks, Allen!

My client wants to be able to order and size the columns -
I'd hate to have to program THAT functionality in Continuous forms.
I've found that I can check the y value on the MouseDown -
if it's less than 255, I'm in the "header".

I still haven't figured out the question in my other post, though.
Even if I set the application's Shortcut Menu to my custom menu, when I
right-click on the "header" of the subform, I get the default shortcut menu.

Any ideas on that one?
- Turtle

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...

I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that I'm
clicking in the header and not somewhere in the detail section.

[Allen Browne]

Nah.

Actually I rarely use datasheets, precisely because the client can resize
and hide columns. Ever had users asking where the column has gone, and how
to get it back?

"MacDermott" <ma********@nospam.com> wrote in message
news:al******************@newsread3.news.atl.earth link.net...

Thanks, Allen!

My client wants to be able to order and size the columns -
I'd hate to have to program THAT functionality in Continuous forms.
I've found that I can check the y value on the MouseDown -
if it's less than 255, I'm in the "header".

I still haven't figured out the question in my other post, though.
Even if I set the application's Shortcut Menu to my custom menu, when I
right-click on the "header" of the subform, I get the default shortcut menu.
Any ideas on that one?
- Turtle

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...

Datasheet view is just a view. It doesn't expose sections like that.

If you work in Continuous Form view, you can detect that the label you
clicked on is in the Form Header section.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MacDermott" <ma********@nospam.com> wrote in message
news:Hz******************@newsread3.news.atl.earth link.net...

I have an Access 2000 form with a subform in Datasheet view.
When I click on an item in the header of the subform (the title at the top of one of the columns), I'd like to be able to capture the fact that I'm clicking in the header and not somewhere in the detail section.

[David W. Fenton]

Al*********@SeeSig.Invalid (Allen Browne) wrote in
<3f**********************@freenews.iinet.net.au> :

Actually I rarely use datasheets, precisely because the client can
resize and hide columns. Ever had users asking where the column
has gone, and how to get it back?

Why not have the form set all columns to a certain width in the
datasheet's OnLoad event? Then if the client has the problem, they
can close and then open the form to see all the columns.

I don't use datasheets much, either.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc