?
Solved

Report formatting

Posted on 2011-10-03
5
Medium Priority
?
204 Views
Last Modified: 2012-05-12
I've added a subform to a report in the details pane and it's displaying the scrollbars and alternating grey and white on each line.  How do I remove this? The subform is a continious form. See attached img.
ee-subform.JPG
0
Comment
Question by:gcgcit
  • 3
  • 2
5 Comments
 
LVL 49

Expert Comment

by:Dale Fye
ID: 36904604
I've never actually added a subform to a report.  I generally convert it to a report, then added it as a sub-report.  Since reports don't have record selectors and nav panes you don't have to worry about those.
0
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 36904635
if you insist on putting the form inside the report, you could probably use the Report_Load event to modify the RecordSelectors and NavigationButtons properties, something like:

Private Sub Report_Load

    me.sub_Form.form.recordselectors = false
    me.sub_Form.form.Navigationbuttons = false

End sub
0
 

Author Comment

by:gcgcit
ID: 36904684
That worked for the navigation thanks - how do I get the grey of every other line removed?
0
 
LVL 49

Assisted Solution

by:Dale Fye
Dale Fye earned 2000 total points
ID: 36904701
try:

me.sub_form.form.section(acDetail).alternatebackcolor = me.sub_form.form.section(acDetail).backcolor

0
 

Author Comment

by:gcgcit
ID: 36904749
That worked. Thanks. I have another formating question but I'll pose a new question to make it fair for point allocation.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month17 days, 10 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question