Different form size in Datasheet View

[SimonPGreen]

Hi all,

I have a form that I wish to display in form view and datasheet view. Unfortunately the form size defined for the form view doesn't work for both views.

Is it possible to resize the form at run time in VBA so that one form can be used for both purposes or do I have to create two forms?

Regards,

Simon

 

[PHV]

Have a look at the DoCmd.MoveSize method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886