Moving Cursor and get coordinates to top-left of control in an MS Access Datasheet subform (1 Viewer)

[Mohsin Malik]

Hello, does anyone know how to move the mouse cursor programmatically to the left side of a particular control within a datasheet view of a subform. To clarify I am looking for a way to obtain the x/y coordinates GetCursorPos for the current record's specific control in datasheet.

 

[The_Doc_Man]

Here is how you get and set cursor position:

Visual Basic Procedure to Get/Set Cursor Position - Microsoft Support

support.microsoft.com

Here is how you select a specific row in datasheet view.

How to Select a Row in a Datasheet

I want to select a row in a datasheet (I want to turn the whole row black). Is there any way to do this from VBA? I've tried messing with the selHeight and setTop settings but they seem to act as read-only. Thank you, Evan

www.access-programmers.co.uk

These two should get you started.

 

[CJ_London]

You will also need to reference the forms columnwidth property for each control to the left of the required control. This may be problematic if the user has reordered the columns or the columns are set to autowidth which has a value of -2