How to Make Small Size Form in Access at Run time.

[Guest]

Dear Sir

Want to Make Size the Form according to the Control which i have place
form.I have even three Subforms but it only gets avtivate upon the user
selects the condition at run time .So even if the i put the subforms at
design time and when at run time the subforms are not on the screen..its
display Blank Splace which subforms was been place at Design Time.
So please tell me how to remove the Blanks Spaces from the Form at run time.

Thanking You

Husain Nagri

 

[Guest]

If I understand you correctly, you want to make the subforms invisible if not
needed ?
If so then you can use a button and onclick... put something like this

If Me.Button.Caption = "Show" Then
Me.Yoursubform.Visible = True
Me.Button.Caption = "Hide"
Else
Me.Yoursubform.Visible = False
Me.Button.Caption = "Show"
End If

Then this will only be visible when you choose it

 

[Guest]

No sir..when the forms load in run time..i do not want the Blank splace which
accutally been used in subforms in design view.
for example.:
Main forms has three subforms..on the condition in run time forms will be
load..but at design time only this forms been place on the form which take
place as contonl and at un time which forms are not visible so that place
seen is blank..that blank space i do not want..

Thanking You