Solved

VB3 Flexgrid column disappears when mouse dragged from right to left

Posted on 2008-09-30
2
253 Views
Last Modified: 2013-12-26
I have to put an old VB3 application on an XP PC.  It is using a flexgrid with four columns.  I noticed if you click a mouse on the last column on the right of the flexgrid and hold the mouse down and then drag it over to the left past the left that the left-most column disappears.  But if you keep the mouse clicked down and drag it over past the left margin of the flexgrid that the left-most column reappears.  I'm in the field and don't have time to upgrade to vb6 or higher.  Is there some way to have vb3 ignore a mousemove?  This only happens if I click and drag starting in the right-most column.  All columns stay visible if I start the click and drag event in any column other than the last.  I want to be able to click in any row to highlight the row, and that works fine right now.  It's only the click and drag to the left that causes problems.  There is no requirement in the software for someone to use a mouse drag type of event.  Thanks!
0
Comment
Question by:pg6111
2 Comments
 
LVL 13

Assisted Solution

by:game-master
game-master earned 250 total points
ID: 22676567


good afternoon!

in vb6 there is a flexgrid property "AllowUserResizing". If you find it on vb3
you may set that like this ... AllowUserResizing =flexResizeNone .... using these
code the columns and the rows of the flexgrid cannot be drag anymore...


i hope this will give u idea...

game-master
0
 

Accepted Solution

by:
pg6111 earned 0 total points
ID: 22994707
There is no AllowUserResizing property in vb3.  What worked was changing the number of ScrollBars to 0 whenever there was a mouse click event in the grid, and then resetting the number of ScrollBars back to what it was before the mouse click event.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

759 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

19 Experts available now in Live!

Get 1:1 Help Now