Remove Headers from Datasheet View?

[pinkpanther]

Can the Headers on a Datasheet View Subform be removed. I want to put
the headers on the Form Header so they are cleaner and easier to read.

TIA,
Larry

 

[John W. Vinson]

Can the Headers on a Datasheet View Subform be removed. I want to put
the headers on the Form Header so they are cleaner and easier to read.

Datasheets are really inflexible... and too flexible (users can resize the
columns so your cleaner headers would end up in the wrong place).

Consider using a Continuous view subform instead. This has an optional Form
Header in which you can put labels as readable headers; adjust their size or
position or font; the form controls are stable... It's a bit more work to set
up but much more satisfactory in the end.

 

[Mark Andrews]

Here's an example:

Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open
'Hide certain columns in datasheet view
Me.Controls("txtAccountID").ColumnHidden = True
Me.Controls("txtContactID").ColumnHidden = True
Err_Form_Open:
End Sub

HTH,
Mark
RPT Software
http://www.rptsoftware.com

 

[pinkpanther]

Consider using a Continuous view subform instead. This has an optional Form
Header in which you can put labels as readable headers; adjust their sizeor
position or font; the form controls are stable... It's a bit more work toset
up but much more satisfactory in the end.

I thought of this early this morning. I must have lost site of the
forest because of the trees. Thanks for the reply and confirmation
that I’m on the right track.