Solved

vfp9 grid shows to many lines

Posted on 2013-06-28
3
548 Views
Last Modified: 2013-07-18
Hi Experts
i have a table that got 35 records, when I display them in a grid grid shows more lines even after the last record. How can just show same number of lines in a grid as records of a table.
After the last record I do not want to show more lines.
Thanks
0
Comment
Question by:b001
3 Comments
 
LVL 27

Expert Comment

by:CaptainCyril
ID: 39285606
Make the grid smaller or make the RowHeight bigger. You can also disable the scrollbars and make the grid ReadOnly.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 39286336
Grids always scroll up to the point the last record is at the top line in the grid, there is no way to stop that.

If you set all columns sparse=.f. and set the grid.backcolor to a light grey you can visualize this part is empty. But that may introduce other problems, when you want sparse usage of a control just in the active record.

You could start trying automatic back scrolling, but forget about it, you rather should live with that grid behaviour or use another (activex) grid, if you can't live with that. But you'd always lose the ability to simply bind a DBF/view/cursor and need code to populate alernative grids.

Bye, Olaf.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 39286493
@b001: If this is the last problem in your VFP application than you have my deep respect.

My favorite solution from Olaf's answer is "you rather should live with that grid behaviour".

To change this VFP grid feature is almost impossible. In addition to Olaf's answers you may try some more crazy solutions, e.g.

1) Ask Microsoft for a paid hotfix
2) Ask China programmers to make this change for you. They released several unofficial hotfixes already. See http://www.baiyujia.com/vfpcompiler/en/default.asp for more details.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
VFP on Windows Server 2 356
FoxPro in WIndows 10 23 3,526
Life afer Fox Pro 3 78
VFP error in production environment but not in development 7 87
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 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