Line breaks in a report

[Neil B]

I have a tabular report of an address list which is sorted by street. I want
to line break when the street name changes and insert the new street name in
caps on the left. How would you go about doing this???

Thanks, Neil

PS: I'm new to the report functions in MS ACCESS

 

[Marshall Barton]

I have a tabular report of an address list which is sorted by street. I want
to line break when the street name changes and insert the new street name in
caps on the left. How would you go about doing this???

Create a group with header (View menu, in report design
view) using the street name field. Move the street name
text box to the group heder section and set its Format
property to > to capitalize the street name.

If you want each street to start on a new page, set the
group header section's ForceNewPage property to Before
Section.