Datasheet headings

[Luke Bellamy]

Hi - anyone know of a way you can control events on the datasheet column
headings?
I would like to be able to do something if the user simply clicks on the
column heading in
datasheet view.
Currently when you view the events for a label bound to a text box (the
label becomes
the heading in the datasheet) there are no events you can define with it.

Any ideas appreciated?

Thankyou,
Luke Bellamy

 

[Stephen Lebans]

Luke off the top of my Head I believe the Form Click event is what
you're after.
There is code on my site to determine which Column heading the Mouse is
over. See:
http://www.lebans.com/autocolumnwidth.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.