Scrolling controls into a visible/non-visible state

[flint]

Is there a way to scroll several rows and columns of controls (txtfields & labels) so that my users can scroll through the products? (The products are labels) In the next column I have textfields that allow the user to enter expenses...the next column shows the market share as a percentage (these are labels as well)...and on and on.

I currently have all the products on 2 forms listed in rows (approx. 16 products altogether)...I wanted to use one form that would allow the user to use a vertical scroll through 7 columns & 18 rows of controls. Can I do this?

I thought maybe that I could run a select case analysis that detects the value of the vertical scrollbar and changes the visible property and position of the controls on the change event of the scrollbar. There must be a simplier way!

Flint

~*I would like to avoid the MSFlexGrid if possible*~

You can't depend on your judgement when your imagination is out of focus.
- Samuel Clemens

[Edited by flint on 10-11-2000 at 10:12 PM]

[honeybee]

There is no simple way from what I think. But if you do find one, email it to me.

Why don't you want to use MSFlexGrid? After all, it comes free with VB, right?

And it's a lot easier to work with the grids, rather than creating its effect with labels and textboxes.

Another way I wouldn't advise is create your own grid-like control.

[flint]

Thanx Honeybee.

I wanted to avoid MSFlexGird mainly because I'm unfamiliar with it, my project is finally working fine as it is, and the project deadline is around the corner.

I assume that I can use drop down boxes and text field input in selected cells of the MSFlexGrid. I'll look in to more.

If anyone know how to overcome the scenario in my first message please share the knowledge.

Flint

THE WORLD IS FULL OF WILLING PEOPLE SOME WILLING TO WORK - THE REST WILLING TO LET THEM

[flint]

I think that I have found a "rigged" solution. Would anybody care to agree or disagree with the methodology?

Create all 16 product controls for each row on one form > use the visible property combined with the Hieght & Width and Left & Top properties this is entirely possible.

I have two input pages for the products > the first page (frm2) inserts the product text on frm4 with the change event of the combobox > same for the second page.

THE PROBLEM that I am running in to being able to identify the first "empty" product label on frm4 when I select the products on frm3. Any suggestions?

Flint

[Quote}
It's like the coming of civilization.
(Anonymous Moscow Resident), opening of the first Russian McDonalds Restaurant, Moscow, 1990
[/Quote]