473,890 Members | 1,359 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

379 Contributor
I know how to set this Property, but what I'm really asking is how I can set it to something smaller than it wants to be.

On a continuous subform, I have a set of fields (all at the bottom of the Detail section) that normally I want to be invisible. On the click of a button, I want to set all their Visible properties to True.

So when the fields are invisible, I'd like to set the height of the Detail section to exclude the "real estate" reserved for the invisible fields, and then, on the click of the button, reset the height at the same time that I set the visibility properties.

Can this be done?
Jun 30 '11
39 12808
12,516 Recognized Expert Moderator MVP
To do this, refer to post #14 for pseudocode. But in short, set the top of the tab control. Move all the controls in the tab control. Set the height of the tab control.
Jul 5 '11 #21
32,584 Recognized Expert Moderator MVP
Just a thought (so I'm not certain it will work) but would cutting (not copying) and pasting of the tab control work?
Jul 5 '11 #22
12,516 Recognized Expert Moderator MVP
That would have to be done in design mode wouldn't it?
Jul 6 '11 #23
32,584 Recognized Expert Moderator MVP
I'm not absolutely certain. That's certainly what I was suggesting, but such things are often supported in code too. I would have thought doing it in design mode made more sense anyway, whatever the capabilities of the code are.
Jul 6 '11 #24
379 Contributor
Just so it's clear: I need to be able to make this change at the request of the user.
Jul 6 '11 #25
32,584 Recognized Expert Moderator MVP
Just so it's clear:
I'm afraid that clarifies nothing for me Sue. What did you mean to indicate?
Jul 6 '11 #26
379 Contributor
Maybe I don't know enough about when design mode is available to me, but I assumed that, once I deploy a front end, and the user is actively using it, design mode would not be available to that user. (at least, I would certainly hope that my users don't find themselves in design mode--they wouldn't have the faintest idea what to do!)
Jul 6 '11 #27
12,516 Recognized Expert Moderator MVP
If they have the full version of Access, and they are not using a runtime version of the database, they have access to design mode.

If the front end is stored locally on their drive as opposed to on a network location, it should not be a huge problem to use design mode if you want to.
Jul 6 '11 #28
379 Contributor
Okay, I guess I really don't understand. Are you saying that design mode is something I can code right into the procedure for the users' button? If that's so, then I have absolutely no idea how to execute design commands from code.
Jul 6 '11 #29
12,516 Recognized Expert Moderator MVP
I think you can but I've never had to do it myself.
Jul 6 '11 #30

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Kevin Myers | last post by:
How can one obtain obtain the height of a MS Access 2K form? There is a width property, but I don't see a corresponding height property. I need to obtain the height of the form so that I can dynamically resize an object on the form in the form's Form_Resize method when a user resizes the form, both horizontally and vertically. Thanks, s/KAM
by: ILCSP | last post by:
Hello, is there a way to display a button in the detail part of a continous form ONLY for the last record? I want to have an "ADD" button at in the same row as the last record, but if I place it there, it becomes an all or nothing issue- it displays in all the records. Is there a way I can first set the property to invisible and then using some code to display this button only in the last row? Thanks.
by: xbox | last post by:
Hi, Its weird bu I cant seem to change the height of the textbox that I place on a form at design time. ideas? Thanks in advance, xbox
by: K.N.Ranjit | last post by:
Hi, This is the 4th mail I'm sending regarding this problem. I'm really not been able to sort this problem out.I'm not been able to change my starting position of my cordinates from top-left to bottom-left of my form.Thrice I got the reply but unfortunately it did'nt work.Here is my coding. private sub form_load(...) dim y as integer y=me.height location.y = 0-y
by: green51 | last post by:
I am tracking projects with the month, start date, end date and the individuals assigned to the project. There will be anywhere between 1 and 14 individuals assigned to the project. I have a query that groups all of this information together their name are in a combo box; I also have set the CanShrink box to “YES”. The extra white space is in the Detail part of the report. My problem is when I generate a report the same amount of space between...
by: beenanic | last post by:
How I can read a parameter from a multi-part form?
by: happyse27 | last post by:
Hi All, How do I change the height of the main menu as the height is inconsistent due to some of main menu's item stretches to 2 rows while, the other main menu's items are stretched to 1 row. Code is below Cheers... Andrew
by: gmiotke | last post by:
I know that this is easy for those that know but alas this is not me ;) I have a multi part form that is going to write to a dB. As a point of reference I can offer geico.com (i.e., the quote process) as a model for my project. I need to write a record on the first page and then use the auto number generated from this to populate the child records with the parent's key field. What I was hoping to do is write the record and then...
by: sueb | last post by:
I have a new single-table database (it hasn't been released to the users at all yet) in which I've created two forms that look at the same data: one form which has a spread-sheet-like format, and displays a few fields for all the records in the table, and another form that displays all the fields for a single record at a time. I'd like to be able to have a button on the summary form that opens the detail form for the particular record selected...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.