Datasheet: double click in cell-column name?

F

faberk

How can I determine the name of a column if I click in a cell of a datasheet?

+ How can i determine for the same double click the data contained in the
first and second cells of the same record.

Your help is welcome and very appreciated :eek:)
 
K

Klatuu

Only jails and Excel have cells. Access (A Database system, not a
spreadsheet) has fields in tables and controls on forms. Fields in the forms
recordset are bound to controls. You reference the value of the control.

When you click on a control in a record in datasheet view, the record you
selected becomes the current record, so querying the name of the control will
give you the value
Me.FirstControl or Me.TheNextControl (The names are made up)

At any time you want to know the name of the control, you can use the
ActiveControl method to return the name of the control.

Screen.ActiveControl.Name
 
F

faberk

Hi Klatuu,
Thanks for your response. I apologize for the reference to cells. The
datasheet holds an eerie resemblance to excel cells :eek:).

What i need to find out when i, double click within the datasheet, is the
column name and the values in the first two fields of the datasheet for that
record.

Can you help me?
 
K

Klatuu

You question was answered in my previous post, please reread it. You can
doulbe click, but a single click is sufficient. I seldom use the double
click, because when you double click, the click event fires then the double
click event fires.
 
F

faberk

Klatuu,
I apologize for the 'cell' reference. The datasheet control has an eerie
resemblance to ms excel.

My question is that when I click within the datsheet control (anywhere), on
a record, how can i retrieve the column name for the point that I clicked on
the record
Below: If i click where the "x" is indicated, how can i retrieve the column
name of "Feb"??

Jan Feb Mar
rec1
rec2 X
rec3

Many thanks
 
Top