Access Form Question - Freeze Part of Form

[ksu176]

In MS Access Forms, how is it possible to freeze a top portion of the form. To be more specific when I scroll down in a form I want the top to stay. Similar to freezing cells in Excel. Is this even possible? Thanks for any help that is out there.

 

[SkipVought]

Hi,

You might want to post this question in Microsoft: Access Forms Forum702



Skip,

_[red][/red]

 

[fneily]

Again, post Access questions in the Access Forums - you'll get more responses.
If your form is in "datasheet view", then on the OnOpen event, you can place code such as, (This example shows three columns being frozen. Change fieldnames to yours and subtract or add fields)

Private Sub Form_Open(Cancel As Integer)
Me.Controls("BillID").SetFocus 'Column Name to freeze
DoCmd.RunCommand acCmdFreezeColumn
Me.Controls("strDescription").SetFocus
DoCmd.RunCommand acCmdFreezeColumn
Me.Controls("IntVendorID").SetFocus
DoCmd.RunCommand acCmdFreezeColumn
End Sub

 

[GeekGirlau]

Put any controls you want "frozen" in the form header.