MS Access database support - Why does detail section scroll behind header?

Author

Why does detail section scroll behind header?

2D Rick

2006-02-20, 1:24 pm

In Access2003 and XP.
My forms detail section hides behind the header when I scroll down to
see controls off screen.
This is similar to freezing a pane in Excel. I'd rather this did not
happen but can't find the property that controls this.
When the form first opens some of the controls are behind the header
and scrolling is required to see them.
Help, thanks, RICK

tina

2006-02-20, 8:24 pm

to make sure that the form opens with the "top" of the Detail section
showing, here's what i usually do: add an unbound textbox control at the
very top of the section, i call it txtTabStop. set the *label's* Visible
property to No. set the control's BorderStyle and BackStyle properties to
Transparent, Height and Width properties to zero (0), Locked property to
Yes, and TabIndex property to zero (0). now the form will open to the top of
the Detail section. alternately, if you don't want the user to have to tab
through the txtTabStop control, you can set the properties as described
above, and also set the TabStop property to No. in the form's Current event
procedure, add the following code, as

Me!txtTabStop.SetFocus
Me!ControlName.SetFocus

replace ControlName with the name of the first control you want the user to
"land on", as he/she moves from record to record.

to have the controls in the form's Header section "scroll out of sight" as
you scroll down the form, you'll have to move the controls out of the Header
section and into the Detail section. there is no "freeze/unfreeze"
property - the Header section is fixed at the top of the form, and that's
that.

hth

"2D Rick" < rbrowniii@compuserve
.com> wrote in message
news:1140462783.350348.39690@f14g2000cwb.googlegroups.com...
> In Access2003 and XP.
> My forms detail section hides behind the header when I scroll down to
> see controls off screen.
> This is similar to freezing a pane in Excel. I'd rather this did not
> happen but can't find the property that controls this.
> When the form first opens some of the controls are behind the header
> and scrolling is required to see them.
> Help, thanks, RICK
>

Jeff Smith

2006-02-20, 8:24 pm

"2D Rick" < rbrowniii@compuserve
.com> wrote in message
news:1140462783.350348.39690@f14g2000cwb.googlegroups.com...
> In Access2003 and XP.
> My forms detail section hides behind the header when I scroll down to
> see controls off screen.
> This is similar to freezing a pane in Excel. I'd rather this did not
> happen but can't find the property that controls this.
> When the form first opens some of the controls are behind the header
> and scrolling is required to see them.
> Help, thanks, RICK
>

Hi Rick

The form header always stays in the same position when scrolling the detail
section. If your controls are hidden here's a few things to look at.
1) In design view reduce the size on the form footer. This will make the
detail section have more screen room and reduces the amount of scrolling
needed.
2) Also in design view reduce the size of the detail section if possible. If
you have too many controls on the detail section you may not be able to do
this. Moving the controls around into different locations would help but
you've placed those controls there for a reason so moving them may not be
feasible.
3) If you can move all the controls around so that they all fit on the
screen, turn off the scroll bars for the form.
4) Set the tab order so that the first upper most control has the focus when
you open the form.
5) Change the screen resolution. This is not a very good solution but you'll
be surprised have mush more screen room you have when you change from 800 X
600 to 1024 X 768. If your screen resolution, or the screen resolution on
the target pc, is a certain size, develop at that resolution.

HTH
Jeff

2D Rick

2006-02-21, 9:23 am

Thanks for the reply
RICK

2D Rick

2006-02-21, 9:23 am

Thanks for the reply
RICK

Sponsored Links