Prevent subform to "shift"

[DianePDavies]

I have a form with a subform. I navigate in my subform with the tab-key and
eventually I enter the subform.

If I have not sized the subform correctly, it "shifts" to the left to show
all of the subform when the control moves to a field in the subform.

Can I somehow disable that behaviour?

I know that proper sizing of the form elements and the subform in the
mainform can solve this - but it can be a quite tedious process if you want
to maximize your subform.

 

[Tom van Stiphout]

On Thu, 13 Aug 2009 02:53:01 -0700, DianePDavies

This behavior is normal if your subform control is smaller than the
content of the subform. Your only option is to resolve that. What you
call tedious others call "attention to detail"
Perhaps it helps if you temporary change the background color, so you
can better see where you are.

-Tom.
Microsoft Access MVP

 

[DianePDavies]

OK.

Another issue is the fact that to keep the "sunken" look of a control in a
subform, it has to be set slightly off the edge of the background in the
subform. That makes aligning of controls to labels on the main form - or
other controls on the main form - a manual process where controls are nudged
in place.

Any suggestions on how to improve that?

 

[Arvin Meyer [MVP]]

OK.

Another issue is the fact that to keep the "sunken" look of a control in a
subform, it has to be set slightly off the edge of the background in the
subform. That makes aligning of controls to labels on the main form - or
other controls on the main form - a manual process where controls are
nudged
in place.

Any suggestions on how to improve that?

"Nudging" is easily accomplished by using the arrow keys, and/or the Ctrl +
Arrow keys on the selected control(s).

Shift + Arrow nudges the size.

You can also enter tiny increments in the property sheet.

 

[Tom van Stiphout]

On Thu, 13 Aug 2009 11:51:02 -0400, "Arvin Meyer [MVP]"

In an extreme case, where MANY controls needed to be put EXACTLY where
we wanted them, we wrote the entire positioning in the Report_Open
event. You can do the same with forms controls.

-Tom.
Microsoft Access MVP