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" <macdermott@nospam.com> wrote in message
news:algHb.11344$IM3.2259@newsread3.news.atl.earth link.net...[color=blue]
> 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[/color]
menu.[color=blue]
>
> Any ideas on that one?
> - Turtle
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:3fed4b91$0$1724$5a62ac22@freenews.iinet.net.a u...[color=green]
> > 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" <macdermott@nospam.com> wrote in message
> > news:Hz7Hb.11058$IM3.5367@newsread3.news.atl.earth link.net...[color=darkred]
> > > 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[/color][/color]
> top[color=green][color=darkred]
> > > of one of the columns), I'd like to be able to capture the fact that[/color][/color][/color]
I'm[color=blue][color=green][color=darkred]
> > > clicking in the header and not somewhere in the detail section.[/color]
> >
> >[/color]
>
>[/color]
