[AccessD] Wacky height of record selector rows on a continuous form subform

Yeah, I would give you some stiff competition there Bill with doing crazy things with Access....  Trouble is we both know Excel is so much better so we have never really come to terms with Access's shabby weirdness ;) hehehehe...   Better get that flame suit ready....



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William (GE Global Research, consultant)
Sent: Wednesday, 28 March 2012 1:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Wacky height of record selector rows on a continuous form subform

OMG the answer was so simple... I had the detail section too tall, not snugged up against the bottom of my controls.

Was there ever someone as dumb as me?


-----Original Message-----
From: Benson, William (GE Global Research, consultant) 
Sent: Tuesday, March 27, 2012 10:25 PM
To: Access Developers discussion and problem solving
Subject: Wacky height of record selector rows on a continuous form subform

Please Please Please someone respond quickly, I am ready to take the bridge, and I am not talking about a card game.

I spend hours after deciding to switch to a continuous form, to have that be the default view of a subform. I painstakingly set the controls exactly where I wanted them in design view on the subform, before putting it as a subform on the main form.

When I run the main form, the sizes of the rows are all too large, and nothing like what they were when the subform is run by itself.

This code only shrinks the controls, it doesn't change the height of the recordselectors.

Private Sub Form_Load()
Dim ctrl As Control
Dim T As Control
Set ctrl = Controls("My Sites and My Products For Warranty") Dim f As Form Set f = ctrl.Form For Each T In f.Section(0).Controls
  T.Height = 400
Next

End Sub

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com