Hi.
Does anyone know how to get
Private Type RECT
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
active cell in datasheet form?
Active cell in datasheet form doesn't hwnd.
Hi.
Does anyone know how to get
Private Type RECT
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
active cell in datasheet form?
Active cell in datasheet form doesn't hwnd.
RECT's are only valid for windows - datasheets don't have windows
best I can suggest is vba code to do the following
left:sum of columnwidths to left of column
right: left+width of column in question
top: more complicated - (determine position of record in dataset-position of top visible record in window) * rowheight - there is code around that can do that, you'll have to search for it unless another responder happens to know. Take a look at this site http://www.lebans.com/
bottom:top +rowheight
Probably easier to create a continuous form that looks like a datasheet - then you can get the RECT of the active control - probably still need to know the record position in the window to adjust the top/bottom values
Why do you need to know? there is often more than one way to achieve the objective
That's for windows forms, not access forms - what is wrong with using a combobox?
Your question is about access forms isn't it?
Accessibility Insights For Windows shows the parameters of any windows, including access forms.
Combobox has a limit on the number of list entries.
Yes. Access datasheet forms.
so to be clear what you are showing in post #3 is an access form?
why would you want more than 65000 records in a combo?
I'm not certain exactly what you want
In case it helps, have a look at the examples in my article: Accurately Move Forms & Controls (isladogs.co.uk)
You will need to use a continuous form instead of a datasheet. You can make it look like a datasheet however.