Form Orentation

[DFowler]

At current i have a form which has an action taken combo box, on the selection of a specified action taken it opens a new form to be populated but..... and here is where my problem lies, The form it opens it opens in the center of the previous form wheras i need it to be opened in the right hand side of the screen so data from the original form is still visible, Its probably something really simple but its a friday and well y'know

Cheers D

 

[Mike375]

MoveSize does it.

That lets you put the form anywhere on the screen. Also lets you decide the height of a continuous form when it opens.

 

[DFowler]

When u say movesize does it?, sorry bit of an access newbie here can you explain pls?

 

[Mike375]

You have Right, Down, Width and Height

Right and Down position the form.

You don't have to list all four of them. For example if you only us Down then you control how far the form appears from the top of the screen.

I don't know how it would go if you run your data base from maximise.

 

[DFowler]

Sorry i really didn't explain myself very well previously, Is there anyway i can have this done on open via vba coding for the form itself ifso do you know how the code would look?

 

[Mike375]

DoCmd.MoveSize , 86, , 7089

That code is from a macro conversion where MoveSize was

Right
Down 0.152cm
Width
Height 12.503cm

It is a continuous form. As you can see I have left Right and Width empty. If it was a small non continuous form that I wanted to open so as to neatly fit the top corner of a larger form them Right would have and entry.

Whether code or macro you can put either of the Open even OnCurrent or if you use code or a macro to open the form then the MoveSize can be part of that.

 

[DFowler]

Cheers that worked great

 

[doco]

Hate to hijak this thread but on a similar note: I have a form that insists on opening to a very wide size even though I can find no control hidden or other wise that would cause the form to grow. I have set AutoResize = No; made sure the details form is reasonable size, etc. I size the form to what it should be then save. But when reopening the form it expands back to an oversize.

Any ideas?
TIA

 

[georgedwilkinson]

Containers (things like tabbed controls) and subforms can cause that. If you have a subform inside a tab and both are expanded out to the right, it causes the form to grow or adds scroll bar.

HTH.

 

[doco]

Interesting. I do have a tabbed control and each page has a subform on it. Allowing more space between the subform and the edge of the tabbed control is the fix?

Thanks....

 

[georgedwilkinson]

Be careful, there are 2 different sets of boundaries on the subform. There is the "external" subform which tells how much space the subform takes up. I usually set this a couple of pixels away from the edge of the expected edge of the tabbed control. This is the subform container that has the master linking properties.

The other, "internal" boundary is just how big the subform "appears" when it is painted. This is the one that has all the data and event properties and holds all the controls.

If this inner boundary is bigger than the outer boundary, it behaves oddly at run time. I've actually had it cause the scroll bars appear on the main access window and push my main form off the screen.

I think I'm describing this right. I've always had to experiment with what looks right.

This is a pain and I've not seen it documented anywhere, not to say it isn't...I just don't know where.

HTH.

 

[doco]

This is helpful. It is interesting though that I haven't run into the problem before. Thanks again...