Controlling form scrolling - force to top left corer when opening

[Guest]

I have an issue that I believe is easily solved.

I've built an application for a client that has forms designed and sized to
fit their screen resolution.

However, I can never count on the form's position and size when the .mdb is
loaded on different machines. When a form is opened, it sometimes scrolls
down to different positions, creating problems for the user. Since we have a
"pretty" background image, controls get shifted all out of place in
relationship to the background. (In know, background images on forms are
generally not good design)

All I need to do is force the form to scrolled to the upper left hand
corner, despite the form's size on whatever machine the db is running.

Can this be done through properties? Or, do I need to use VBA. I'm very good
with VBA so I'd be happy to try it.

Thanks!

Jimbo

 

[Chris Reveille]

Try
http://www.mvps.org/access/api/api0029.htm

Chris

 

[Stephen Lebans]

Generally, you would SetFocus to an exisiting control located towards
the top of your Form. Access then would automagically scroll this
control into view.
If this is not sufficient then see:
http://www.lebans.com/setgetsb.htm
SetGetSB.zip is a database containing functions to allow a user to Set
or Get the current position of a ScrollBar Thumb for a Form.

NEW - Apr. 02/2000 The current ScrollBar position is equal to the
current Record Number being displayed at the Top of the Form.

Works in Form or Datasheet view.

Ver 1.7

Fix bug in SelTop method. Now works with first page of rows properly and
sets the Top row correctly when moving forward in the recordset one row
at a time.

Ver 1.6

Use SelTop to save Restore current row's position after a Requery.

Ver 1.5

Added support for Horizontal ScrollBars.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.