Programatically scroll form in window.

[lamarw]

Hi all,
This is the best forum around.
I have a form 22" wide which is in three sections. It is viewed in an unsizeable window approx. 7" wide. I want to click on a button to slide (scroll) the 22" form left or right in approx. 7.33" increments to bring the next/previous section into view.
When the horizontal scroll bar is enabled I can manually do exactly what is needed. Is there a way of doing the same thing programatically?
I've tried using the .move(Left, Top, Width, Height) but that moves the window and the form.
Any ideas/help is always very much appreciated.

Lamar Washington

 

[SkipVought]

Lamar,

What event would trigger this procedure? How would hitting the 'trigger' be any different than punching the scroll bar?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TheAceMan1]

How are ya lamarw . . .

Why not use a 3 page [blue]Tab Control[/blue]?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[lamarw]

The event would be the button push. Okay, okay, it is a little extravagant but I'm trying to make this as friendly and usable as possible.
This interface is used as the main data entry point. Right now it's a form (I didn't design it) full of fields that is very difficult to navigate. The fields don't correspond to the layout of the form from which the data is retrieved, I'm changing that. The form groups fields together, I'm doing to that as well. At the same time I'm trying to reduce the number of fields that are presented thus the scrolling to the 'Next' group and the buttons to go to Next and previous.
I want, no only to make it much more user friendly but to also add a little 'coolness factor' that will bring the data entry people back to a positive attitude using it.

 

[lamarw]

Hi AceMan,
I was thinking of using the tab control, I will as a last resort if there is no way to do the scrolling thing programatically. Any ideas on that?

 

[lamarw]

Incidentally, the three tab control will involve alot of recoding, circumvented by the scrolling method...

 

[TheAceMan1]

lamarw . . .

Your biggest issue will be [red]getting the 1st column of each group to align on the left[/red] of the form!

Note: there's no law that saids the [blue]number of lines[/blue] in the [blue]detail section of a continuous form[/blue] is limited to one! Actually (with labels included) your talking six lines). A record simply has a taller height and is a matter of appeal. When you use the form wizard this is what access does when you select [blue]Justified[/blue].

An alternative would have 3 lines of labels in the header and 3 corresponding lines of data in the detail section.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[lamarw]

I'm sorry, I don't follow. Are you commenting on the scrolling method or the tab control method?
If the scrolling method, I'm envisioning horizontal scrolling.
Incidentally, how did you determine 6 lines?

 

[lamarw]

In any event, I just don't know how to get the scrolling action to occur programatically.