Access 2007 Split Forms

[DavidSemon]

I seem to be unable to control the size (specifically the width) of split forms in Access 2007. It appears that regardless of what settings I use in the form's properties, the form opens wider than I expect. Can anyone tell me what property I may be overlooking? Or, what properties impact the size of the form? Thanks.

 

[WayneRyan]

David,

I don't have A2007 and don't know of "split forms", but the command:

DoCmd.MoveSize

should still be available and might be what you want.

Wayne

 

[DavidSemon]

Thanks, but it is not a programming issue. The form does not seem to behave correctly when I set/reset properties in design mode. For example, if I change the width to 5 inches, save, close and reopen the form, it opens to some width other than 5 inches. When I go back to design mode and check the width, it is still 5 inches. I have read all the help info Access provides, but I must be missing something. I can't believe MS could have released a product with a problem as fundamental as this. So, I must be doing something wrong --- setting some property that overrides the size I set.

Anyway, thanks again.

 

[WayneRyan]

David,

Sorry to hear that, but have you checked out the:

DoCmd.MoveSize

Wayne

 

[boblarson]

Have you gone to Access Options > Current Database and selected the OVERLAPPING WINDOWS option?

 

[DavidSemon]

Bob: Yes, overlapping widows is selected.

Wayne: I assume that your suggesting using DoCmd.MoveSize to force the form to the size I want after it opens. I'll give it a try.

Thanks to both.

Dave

 

[boblarson]

I just saw a post on the Microsoft forums that said something about needing to select ARRANGE > CONTROLS > REMOVE (not sure I have that exactly right and I don't have Access 2007 here at work. If you can't find it to check, I'll look when I get home.

 

[DavidSemon]

Thanks ... I'll follow that trail.

 

[DavidSemon]

Bob: I tried the ARRANGE > CONTROL LAYOUT > REMOVE (which unstacks the controls on the form), but still no success with controlling the size of the form. It is really strange. I don't have any problems with any other form or control ... just these new split forms. I guess I could program something to replicte the split form, but that sort of defeats the purpose of buying a new product with new features.

If you see anything else on this topic, please advise.

Dave

 

[mark161718]

Dave: I know this might be a little late but i came across this thread when i was looking for a solution to the same problem. I am new to access but with a little searching i found that using the code

Forms.Move (

,[top],[width],[height])

you are able to control the size and position of a split form, don't know why docmd.movesize doesn't work but this code seems to work exactly the same. Just simply insert it into a procedure when opening the form.

Regards

Mark

Ps. don't know the units for width etc, but on my screen 500 for width and 100 for height seems to be about 1cm x 1xm​