How to change the height of the 'detail' part of a form?

[NeoPa]

Design Mode is generally available to designers (such as yourself) when designing the various forms and other objects in your database. However, opening an object in Design Mode can also be done using code. It's less common certainly, and comes with a few gotchas that you should be careful of, but the option is there.

Design changes may be made by code when the object (form) is open and in normal use, but such changes are session level. They only persist for the duration of the current session and would not effect another user who had the same object open at the same time. If the object is opened in Design Mode though, and changes are made then the object is saved, this new version becomes the object for future uses. It is very rarely a good idea to work that way, but the facility is available should you choose to (If you hadn't got it before, I certainly wouldn't recommend using this facility).

Sue, You said before :
Just so it's clear: I need to be able to make this change at the request of the user.
I'm still not clear what you meant by that. Did you possibly mean you wanted the user to be able to make such a request of you personally and you would design it into the database? That's what the wording implies.

If you want to design the database such that a user could choose to move the tab control and its contents to another section on the click of a button then that's something else again.

As I say, I'm still not sure.

[sueb]

NeoPa, what I need is the latter: in other words, I want to put a button on a form that displays an otherwise-invisible tab control.

[NeoPa]

From that last comment the solution is easy. Unfortunately, I believe we've already been there and you weren't happy because you needed the tab control and its contents not even to be there as invisible on the form due to the constraints which that put on the size of the section it was contained within. As such, this only seems to leads us around the same circle again.

At one point you were attempting to move the tab control and all its contents into another section. How far did you get with that and was it ultimately helpful?

[Mihail]

Hi all !
Maybe my english is not enough to understand the problem. So sorry if my idea can't work.
Sueb, take a look to InsideHeight command (Me.InsideHeight = ....). I think that is the answer to your problem IF you use Overlaping Windows. For Tabbed Documents do not work.

[sueb]

Mihail, what version is that attachment? I have 2003, and it can't open it.

[Mihail]

Is 2007.

Look: Create 2 buttons (Command1 and Command2) then use the CLICK event for each one.

Private Sub Command1_Click()
    Me.InsideHeight = Me.InsideHeight + 100
End Sub

Private Sub Command2_Click()
    Me.InsideHeight = Me.InsideHeight - 100
End Sub

Do not forget: Overlapping windows for your forms.
Hope the code work in 2003. I can't test it in this version.

[sueb]

Mihail, also I don't know what Overlapping Windows is. Can you please explain?

[Mihail]

I try to explain using my poor English.

I do not know if "Overlappin g Windows" exist in 2003 version.
If you open more forms (2, 3, 4 .... ) in the same time you can see as many windows as opened forms (as usual windows in Windows operating system) but using only the Access window area.

On the other hand you can set the form to be as large as the Access window. In this case you'll see only one form at a time. This is NOT "Overlappin g Windows" (2007 say that is "Tabbed document").

Maybe someone else wish to explain better using a true English :)

[Adam Tippelt]

Basically Microsoft has done for Access 2007 what browsers have done to internet pages - the windows now have tabs to allow the user to easily switch between opened forms within the same Access window, so multiple forms can be open and accessed at once.
Tabs can however be turned off in the database settings if you want to hide them from users.

[sueb]

I see. No, I don't think that 2003 has tabbed windows. What I've done with some of my forms and reports is to "free" them from the Access window area by making them pop-ups. That seems to work pretty well.