Remove Headers from Datasheet View?

  • Thread starter Thread starter pinkpanther
  • Start date Start date
P

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
 
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.
Click to expand...

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.
 
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
 
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.
Click to expand...

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.
 
Back
Top