Hide/Show a row on a multiple items form

[Historypaul]

I'd like to be able to show/hide second and third rows of data on a multiple items form. I thought it would be easy - just modify the height of one of the controls on that row and watch the entire row collapse or grow based on that modification. It's not working. What's weird is, using the below code, it will collapse the row, but not enlarge it.

If ControlName.Height <> 0 Then
ControlName.Height = 0


Else
ControlName.Height = 0.22


End If

[amrut]

What is the default view of form - Single/Datasheet/Continueous
Me.YourControlName.Visible=True or False can set the visibility depending on the if .. then condition you use in case of single form.
If I understand correctly,you are using Datasheet/Continueous view of form. Try with conditional formatting based on values.

[Historypaul]

Default view is continuous.
My goal is to be able to shrink the height of the details section of the continuous form with a command button. I'm just assuming I have to be able to shrink the height of the controls within it first.

[amrut]

If you shrink the height of detail section, all controls will be hidden.
You cannot selectively set the height for second or third row. The height for all the records will be same. So if the height is set to zero, the control will not be visible.
Try with conditional formatting as suggested earlier. Set the font color similar to the background color if the condition is met.This will show an empty text box though it has data.

[Historypaul]

Amrut - If I shrink the height of the detail section to 0", then all controls will be hidden... I have two rows of controls from a single record. I want to be able to shrink the second row of controls and cut the detail section height in half. Shrinking the controls doesn't seem to be a problem, but my code won't increase the height of the controls...

[amrut]

I think that you can shrink those controls and change height of detail section but it will be applicable to all the records and not the selected record only. Never tried.

[Missinglinq]

Just to reiterate what's been said, you cannot do this kind of formatting using a Continuous or Datasheet View Form! In looking at your Form, when you open it, it appears that you have multiple copies of, for instance, the Ref_Dtl or the Remarks Textboxes. But as everyone knows, appearances can be deceiving, and that is the case here! There is actually only a single Ref_Dtl Textbox, and when you do anything to format it, all instances of it in all Records are formatted the same way!

As has been said, with these types of Form Views, you need to use Conditional Formatting and, as you'll see, your options using CF are limited. You can Disable Controls with CF, or make them appear 'empty,' by setting the ForeColor to the same as the BackColor, as amrut suggested, but you cannot make the Controls disappear!

Linq ;0)>

[Historypaul]

I'm perfectly OK with it applying to all instances of the details section. I understand that the details section on a continuous form is just reiterated over and over for each record and I would want it to be modified as I show for every record going down the form. And just by using a command button and the code "on click" of

ControlName.Height = 0
Me.Detail.Height = 0.8

It will shrink the row of controls and the detail sections height just fine. It just won't do the reverse. (enlarge the section)

[Missinglinq]

The setting for Height has to be given in TWIPS (1 inch = 1440 twips) and 0 twips is the same 0 inches, so setting it to 'shrink,'using zero, will work; but setting it to 'grow,' using 2 or 4, or whatever, is being interpreted as 2 or 4 twips, which is 2/1440 or 4/1440 of an inch.

Try using twips when you set it to 'grow.'

Linq ;0)>

[amrut]

I'm perfectly OK with it applying to all instances of the details section.

If this is the case then, here is the solution.
-Note the top margins of the controls in second and third rows ( also for associated labels)as seen in the screenshoot
-change their top margins to 0 and visibility to no
-set the details section's height to minimum
In the click event to show the controls - set theri visibilty to true,top to the values noted earlier
In the click event to hide the controls - set their visibilty to false,top to 0, detail.height to 0

The margins for the control's caption are also required to be set. I tried with only controls, but the associated labels did not moved. Only hiding the controls did not "collapsed" the details section to first row.

[Historypaul]

Missinglinq - you hit the nail on the head. Works perfectly. I just didn't realize I had to give the new height in twips. I thought I was specifying in inches just like you do in the sidebar in the form design mode. When I use the same code, but figure the sizes in twips it works perfectly!

THANK YOU SO MUCH!