Solved

How to automatically scrolldown to the bottom of a grid?

Posted on 2001-06-18
3
141 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now