Set height of a form detail section using VB

[Andrew Fergus]

Is it possible to change the height of the detail section of a form using VB? The height will depend on whether a variable at the top of the form is set to a particular value, or not.
TIA, Andrew

 

[Norie]

Don't see why not.

Me.Detail.Height = 657

This code works but doesn't actually seem to have any visual effect.

What are you actually trying to do?

 

[Andrew Fergus]

Hi Norie and thanks for quick reply as well as the syntax. If I use the code, the screen 'pulses' (so it has accepted the command) but it doesn't resize - as you found out.

What am I trying to do? I have an invoice entry screen, and depending on the type of invoice that is selected at the top of the screen, a whole block of data is no longer required (it is hidden using the .Visible = No command), but I'm left with a great empty piece of real estate on my form (there are other controls in the footer). The intention was to resize the detail section to lose the empty space. It's one of those 'nice to have' things, rather than a 'need to have' - but you know what users are like with the form & report layouts.

I'm thinking I might need to 'requery' the form (if that is possible - much like you do with a query) after resetting the section size with the Me.Detail.Height command.

Thanks, Andrew

 

[Norie]

Andrew

Don't think that will work either.

Why not have another form?

 

[Andrew Fergus]

Do you mean another form embedded in my existing form? Like a subform?

Late edit : the : DoCmd.MoveSize command seems to have the desired effect so I will experiment with it, in conjunction with the Me.Detail.Height.

Thanks for the pointer Norie.

Andrew