Last question for this evening...

[Nightowl4933]

...and I'll try and avoid typing errors!

Is it possible to open a form and specify the size when it opens, please?

The reason I ask is that, when I click a CommandButton to open a continuous form, the number of records varies, but I want the form to stay the same 'height'.

Thanks.

 

[CJ_London]

investigate the form move method

https://msdn.microsoft.com/en-us/library/office/ff845906.aspx

 

[Nightowl4933]

OK, so I see the logical steps to this and understand that, to use this method, I will have to include the Left, Top and Width values to be able to set the Height value.

So, is there a way to determine the first three criteria from the Form this is launched from, so I can use these to set to Move command of the subsequent Form - if that makes sense?

Thanks

 

[CJ_London]

So, is there a way to determine the first three criteria from the Form this is launched from

yes - use the form windowtop etc property e.g.

me.windowleft

see this link (note, not sure if this applies pre 2010)

https://msdn.microsoft.com/en-us/library/office/ff837021(v=office.14).aspx

note also that forms need to be set as modal/popup or overlapping - don't believe it will work for tabbed forms

 

[Nightowl4933]

Thank you. It wasn't as complicqated as I thought!