Changing the form detail height of a subform in MS Access 2010

Posted on 2013-10-02
Medium Priority
Last Modified: 2013-10-02
I wonder if anyone can help with regard to whether it is possible to change the Detail height of a sub form from outside the subform itself?

Forms!NavigationMain!ClientDetails!Frm_CaseSummaryView.Form.Detail.Height = 2580

I need to do this from outside of the form itself. Don't even know if it is possible?

Any assistance would be greatly appreciated.
Question by:martmac
  • 3
  • 2
LVL 53

Expert Comment

by:Gustav Brock
ID: 39539303
It should probably read:

Forms!NavigationMain!ClientDetails.Form.Section(acDetail).Height = 2580


Author Comment

ID: 39539316
Sadly no joy there is no reference to the subform Frm_CaseSummaryView

I should maybe point out that the subform is inside a Navigation Form. So the top level is navigation Main and the form within that is called ClientDetails, then it is that form that contains the subform Frm_CaseSummaryView
LVL 53

Accepted Solution

Gustav Brock earned 2000 total points
ID: 39539342
Then try:

Forms!NavigationMain!ClientDetails.Form!CaseSummaryView.Form.Section(acDetail).Height = 2580

Replace ClientDetails and CaseSummaryView with the names of the subform controls holding the forms Frm_ClientDetails(?) and Frm_CaseSummaryView(?).


Author Closing Comment

ID: 39539382
That's done the trick, thanks very much /gustav
LVL 53

Expert Comment

by:Gustav Brock
ID: 39539398
You are welcome!


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…
Suggested Courses

623 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