Access Hide column header in Sub Form

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I have the following Access form with a sub form that shows the data in a table. How do I hide the column header "GenuineReason" ?

Thanks

1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
I don't think you can.
The column headers are an essential part of a datasheet.
John TsioumprisSoftware & Systems Engineer
Commented:
Just change to Continuous form and hide whatever you like...
Mark EdwardsChief Technology Officer
Commented:
If you don't need to mess with the data - just view it - you can use a listbox with the Column Heads property set to "No" (headers hidden).
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
There is an example in the old Nortwind demo, which comes close using a continuous form with tightly aligned controls:

dw.jpg
You can hide the text in the column heading  by going into design view, and changing the label caption attached to the GenuineReason's textbox to a space.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks for the advice

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial