Line breaks in a report

  • Thread starter Thread starter Neil B
  • Start date Start date
N

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
 
Neil said:
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???
Click to expand...


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