make subform entire width of form

Posted on 2013-08-28
Medium Priority
Last Modified: 2013-08-29
hey guys, no matter what i do i just can't get the subform to fill the entire width of the form. is there something i'm not doing correctly?

subformdesign view
Question by:developingprogrammer
  • 3
  • 2
LVL 10

Accepted Solution

etech0 earned 2000 total points
ID: 39447592
You have to set the anchoring. when you're on the main form, click on the subform ONCE, and set the anchoring to stretch across top. (I'm not sure where it is in the 2007 ribbon, but i can look it up if you need)

Author Comment

ID: 39447631
YOU ARE A GENIUS etech0!!!! = )))))

 it works like magic!!!!! haha = )))) thanks so much etech0!!!! = )))
LVL 10

Expert Comment

ID: 39447645
Glad to be of help! Don't forget to play around with the anchoring options in your forms and subforms. You can do really cool stuff with it!

Author Comment

ID: 39447719
Yup yup definitely!! I've been reading up about this and I think it's one of the most exciting things about Access 2007. Hrmm I'm not sure how it behaves if I set it in Access 2007 and a user uses it in Access 2003 ha = ) guess I gotta test it out but thanks for starting me off etech0!! = ))

Author Closing Comment

ID: 39448143
superb answer by etech0! = )

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question