Two (simple?) forms/subforms appearance questions.

[spimby]

Hello.

I think these should be a simple questions.

1) I have a form which also contains multiple subforms. Most of the
subforms appear in datasheet view. One of them requires a scroll bar
to see all the fields. Even though only (3) fields appear off-screen,
the scroll bar has a lot of extra space in it...which moves the sheet
over so you see all this empty background of the subform (gray area).
How do I make the subform smaller so that the scroll bar is shortened
to just the length needed to view the off screen fields? I've tried
moving everything around, making the forms smaller, etc. I must be
missing something obvious.

2) For the subforms that are viewed as datasheets, is there any way to
remove the field description from the view, so that you only see the
entry field? I have text boxes above the subforms that describe what
they are....and the field descriptions are redundant.

 

[John Vinson]

Hello.

I think these should be a simple questions.

1) I have a form which also contains multiple subforms. Most of the
subforms appear in datasheet view. One of them requires a scroll bar
to see all the fields. Even though only (3) fields appear off-screen,
the scroll bar has a lot of extra space in it...which moves the sheet
over so you see all this empty background of the subform (gray area).
How do I make the subform smaller so that the scroll bar is shortened
to just the length needed to view the off screen fields? I've tried
moving everything around, making the forms smaller, etc. I must be
missing something obvious.

2) For the subforms that are viewed as datasheets, is there any way to
remove the field description from the view, so that you only see the
entry field? I have text boxes above the subforms that describe what
they are....and the field descriptions are redundant.

I think you can solve both problems by abandoning the Datasheet view
and setting both subforms to Continuous. You can use the Form Header
for your descriptive textboxes, and control the size and positioning
of the data; you can even use two lines per record so the user doesn't
need to scroll at all.

John W. Vinson[MVP]

 

[spimby]

Thanks - That worked and looks a lot better.