"Detail" section of continuous form too big

[TUSSFC]

I have a continuous form based on a query. The recordset returned will always be 3 records - but as far as I can see this shouldn't be relevant.

Therefore, I'd expect the form (in form view) to display the form header, the 3 records and the form footer. I've disabled the ability to add new records from the form view - so it's view/edit only.

However ... the detail section showing is quite big. There's a horrible blank bit below the 3rd record and before the form footer and I can't work out what's causing it!

Any ideas?

- see attached screenshot. thanks.

 

[Soulium]

There is VB code you can use to get rid of the lines but i have forgotten it/them, Sorry. You could try googling some VB access tutorials it should be in some of them.

 

[TUSSFC]

Ha, there is hope then! I've tried googling and googling but with no luck. Guess I'm not getting the terminology right :-/

 

[Soulium]

Ahar! Found it! err i may have lied.

Open your form in design view. Go View- Properties- click format- "dividing lines"(10th down) change it to No.

 

[TUSSFC]

Tried that ... no change (except no dividing lines - still big gap) :-(

 

[Soulium]

Oh then you need the min and max size forced and that is VBA =S

 

[Rich]

Try putting some more records in the db, there isn't a can/shrink grow function on forms

 

[TUSSFC]

The form is based on a query ... and the results will always be 3 records. I don't want any more to show. There is a property on the detail part of the form for Can Shrink but I have tried that on/off with no change.

 

[Rich]

The form is based on a query ... and the results will always be 3 records. I don't want any more to show. There is a property on the detail part of the form for Can Shrink but I have tried that on/off with no change.

CanShrink on forms only works when printing the form, if there's only ever going to be three records drag the bottom of the form up to make it smaller

 

[TUSSFC]

Ah ... got it!! I was trying to do it in Design view. Simply dragged the form frame in form view and saved and got it.

Christ ... I feel like a fool *blushes*

Thanks.

 

[bassman197]

TUSSFC:
Drag in FORM VIEW - Thank you! I have been trying to figure this out for years!

 

[ma t]

Can someone explain what "drag in form view" means? I have a form with a subform. The "main" form is set to single form. The subform is in the footer, and is set to continuous. there is a HUGE gap between the record in the main form and the subform. Try as I might I cannot get the subform to "hug" the top of the footer section. I have tried the suggestion of making the footer deeper, but the folks who have laptops or small monitors then get the top of the main form cut off- WHYYYYYYYYY does Access do this? :banghead:

 

[ma t]

i have my form "control" snugged up as far as it can go. my form "expands" as tall as my monitor, making the detail section huge, and the footer, with the subform, all the way at the bottom.... any suggestions ?

 

[ma t]

huh... Access has "all the tricks" i guess... i will try this out. been a mystery for years...

 

[ma t]

btw- your nice illos with the arrows are a very nice touch!

 

[ma t]

so i just changed my preferences, and now the forms seem as "pop up". And, i still have the same issue, one record in the main form, with a huge detail section, with a tiny subform in the footer at the bottom of my monitor...

 

[ma t]

Just uploaded both form and design view. Thanks so much for your help!

 

[ma t]

which version of Access are you using? I see no obvious way of selecting the form edge to drag it smaller in design view... ? I am using 2010.

 

[ma t]

Hello- I've been working on this off and on, i changed to overlapping forms, dragged the boarder smaller, etc, save, and still the same result. Ultimately I will want to have tabbed document, does your solution only work in overlapping? Thanks...

 

[ma t]

What I would like to do is create an event like
Private Sub Form_Load()
Me.Form.AutoResize = False
Me.Detail.AutoHeight = False
Me.Detail.Height = 700
End Sub

But nothing works... so frustrating. I have a detail section (single form) that should only be about .5" tall. In the footer I have a small subform that is about 3" tall. When i go into form view, the detail section expands as big as it can on my monitor, showing the subform at the very bottom. I don't want the detail section of the form to fill my monitor, auto expand, etc. I just want it to be set to what is required to accommodate the controls that are in it, which are only about .33" tall. All help is greatly appreciated! Thanks