Datasheet form to resize with master form

[smercer]

Hi all

I have a subform in data sheet view, and when the user resizes the master form I want the subform to resize with it. I got it to work but, I want the scroll bars to show with out scrolling the master form to get to them. here is my code:

[COLOR=Blue]Private Sub[/COLOR] Form_Resize()
[COLOR=Blue]Dim[/COLOR] F_Width [COLOR=Blue]As Integer[/COLOR]
[COLOR=Blue]Dim [/COLOR] F_Height [COLOR=Blue]As Integer[/COLOR]
[COLOR=Blue]Dim[/COLOR] Adjust_Width [COLOR=Blue]As Integer[/COLOR]


F_Width = Form.InsideWidth
Adjust_Width = F_Width - 1
F_Height = Form.InsideHeight

sfrm_Books_Descriptions_in_Store_subform_DatasheetView.Width = Adjust_Width
sfrm_Books_Descriptions_in_Store_subform_DatasheetView.Height = F_Height

[COLOR=Blue]End Sub[/COLOR]

the line
Adjust_Width = F_Width - 1
seems to be ignored by the form and has no effect

Please note that the forum has put spaces in and has no spaces
Thanks to all in advance!!

 

[smercer]

Thanks Pat

It works perfectly now. Well Done!!

Thanks again

 

[Dylan]

Please excuse the ignorance. I am trying to learn from the great information provided by Pat and others in this forum.

But where do you insert this code? Is it in the main form or the subform. It's just that I can't see a Event called RESIZE

 

[smercer]

Please excuse the ignorance. I am trying to learn from the great information provided by Pat and others in this forum.

But where do you insert this code? Is it in the main form or the subform. It's just that I can't see a Event called RESIZE

see attachment. you insert it in the mainform