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" <rb*******@compuserve.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.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