How to resize the continous form

[vaidehikumar]

I have a form where I have all the data showing from a table to edit the data. It is a continous form with no data entry. Only edits and deletions are allowed. I want to get rid of the extra space after the data in the last column. I tried everything I could in the form properties. Please help me.

I have the screen shot of the form attached. I have selected the extra area in red circle that I am trying to get rid off. Thank you for your help.

 

[Pat Hartman]

Open the subform in design view and drag the right edge in to make it the width you want. Save it and open the main form. Drag the right edge of the subform control in to make it the width you want.

 

[vaidehikumar]

Thank you for your reply. I do not have a subform. I created this based on a Table and it is the main form.

 

[missinglinq]

Then open the Main Form in Design View and do the same thing!

 

[vaidehikumar]

In the design view it looks fine, there is no space after the last column. But in the form view it shows lots of space after the last column. Please take a look at the screenshot attachment of both views. Thank you again for your help and timely reply.

 

[missinglinq]

In Form Design View, you need to grab the very right hand edge, where the Vertical Scrollbar is, and move it to the left until it touches the right edge of the 'Mystery WT' column.

 

[vaidehikumar]

It didn't work.

 

[Pat Hartman]

You are clipping off the Access frame in your pictures. Is the database in Tab view? If it is, there isn't anything you can do. It will always be full screen width.