Form Resize VBA

[Tim L-B]

This is driving me nuts and I am sure there must be a simple solution.
I want to create a popup form that just contains a list box that is resized just to the number of entries in the box. No problem resizing box and form detail, but I have not found a way of resizing the form border. Every method I have used so far ends with the form taking up the same amount screen space. Please Please help the desperate.

 

[MStCyr]

Hi

Check the Sample Databases area, there is a sample in there.

Maurice

 

[Tim L-B]

Thanks Maurice

As often happens you chase your tail trying to find the answer and as soon as you ask someone the answer appears from another source.
Having used Access for a number of years I have somehow missed the wonderful movesize method so the simple solution turned out to be after my

me.Detail.height = me.ListBox.Height + 50

Add

DoCmd.MoveSize 1440,2400,,me.ListBox.Height + 400

Works a treat and thanks again for your help and interest

Tim