Access Form: Hide lines between columns

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

On an Access form how do I hide the inner lines between columns.
They are still showing as in  the image.


1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What view type is the form?
Murray BrownASP.net/VSTO Developer

Author

Commented:
It is a report
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
It looks like a form in datasheetview to me.

Is it a form or report? If a report, just adjust borders of the texboxes to Visible=No.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Murray BrownASP.net/VSTO Developer

Author

Commented:
Hi. It is definitely a report as shown in the image "rptInvoice" and the control is a ListBox
1
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
OK. And the borders of the controls?
Distinguished Expert 2017

Commented:
I don't see any option to turn off the gridlines.  You will have more control if you make a subreport.  You can hide the borders to make it blend it with the report.
Murray BrownASP.net/VSTO Developer

Author

Commented:
How would I use a subreport?
Distinguished Expert 2017
Commented:
Create a report and use the RowSource of the combo as the RecordSource for the report.  Fix it up so it looks the way you want.   Put the report onto the main report and remove all the borders.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Great. Thanks very much

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