No AutoCentering, Please!

[Dugantrain]

I have a form that's pretty large but just does fit on the screen. I'd like for it to remain centered exactly as it is no matter where the user clicks/tabs on the form. I have set the Autocenter and Resize properties to "No", but it doesn't seem to do anything. I will be having users copy and paste about 100 records per day, so having to use scroll bars to manually resize every record will seriously slow the project down.

 

[yippie_ky_yay]

Hi Dugantrain,

If it just fits the screen - why not maximize it?

I'm not sure of experience with Access, so I'll explain every step.

Open your form in design view - go to the VBA code ("View" and then "Code"). Select "Form" from the first drop-down box and "Activate" from the second. Enter the text:
DoCmd.Maximize

Then, select "Deactivate" from the second drop-down list and enter the text:
DoCmd.Restore

Hope that helps and good luck!

-Sean

 

[Dugantrain]

Well, let me rephrase that: The form doesn't entirely fit on the screen, but the part that I want the user to see does. Maximizing won't work as it still Recenters. I'd like for the form to stay put exactly as it is when the user tabs through the fields, but let the user have the option to manually scroll vertically or horizontally using the scroll bars.

 

[yippie_ky_yay]

Hey Dugantrain - sorry for the delay - got busy!

Look into the tab index - it controls the order of where the cursor will go next when you tab (starting with 0 and working it's way up). Try setting the tab index of the first field they will be entering data in to 0 - the second to 1, etc... Whenever the screen loads, the cursor goes to tab index 0 (or the lowest one).

Unfortunately I think you have to specify a tab index for each control on a form in Access (I don't believe you do in VB). You can do some tricks though like make all other controls not visible (you can't tab over to a field that is not visible) for when a data entry person is using it.

That's your quick fix - ideally it would be best to create a new form with just the fields that the data entry people need and try to make it fit on the screen.

Hope that helps,

-Sean