Solved

How to automatically scrolldown to the bottom of a grid?

Posted on 2001-06-18
3
144 Views
Last Modified: 2010-05-02
On a form I have drag and dropped a flexgrid, and with that grid, lots of records have been entered, so many records, in fact, that a vertical scrollbar appeared.
My question is "how do I make it so that when the form is loaded, it is by default, scrolldown to the last entry of the record? "
thanks.
0
Comment
Question by:tomboman
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
JonFish85 earned 50 total points
ID: 6204868
here is what I used:

  FlexGrid.SetFocus
  SendKeys "^{END}", True

hope that helps!
0
 
LVL 6

Expert Comment

by:JonFish85
ID: 6204951
could I ask why its graded as a B? just wondering...
0
 

Author Comment

by:tomboman
ID: 6204993
well, because I had to modify your code a little bit. as follow:

FlexGrid.SetFocus
SendKeys "^{PGDN}", True

In order to scrolldown to the BOTTOM of the grid.

I remember when my teacher told me, if I didn't answer the question, doesn't matter how good the answer is, you won't get the full mark. (or did I not made myself clear? in that case, it would have been my fault) anyway, I really appreciate you for answering my question. If it means a lot to you, I wish I could regrade the answer, somehow.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question