Solved Line Breaks on Field change

[Charlie3]

Thanks, much appreciated. It's too big to send, let me get rid of unnecessary stuff in the DB and try again. I'll be back at my desk tonight and look at it then.

 

[Charlie3]

Hi arnelgp.

The DB is attached. The only changes from what you last provided are that unneeded tables have been deleted and duplicate rows have been eliminated from the cmx table.

In your update, would it be possible to also increase the number of issues per row from 7 to 10, and to eliminate one of the blank rows between titles?

BTW, I spent some time with your code last night. It's been a long time since I've coded, but I follow what you've done. Your code is elegant and cool, kudos.

Thanks,
Charlie

 

[arnelgp]

here is check and try your report.

 

[Gasman]

Hi arnelgp.

The DB is attached. The only changes from what you last provided are that unneeded tables have been deleted and duplicate rows have been eliminated from the cmx table.

In your update, would it be possible to also increase the number of issues per row from 7 to 10, and to eliminate one of the blank rows between titles?

BTW, I spent some time with your code last night. It's been a long time since I've coded, but I follow what you've done. Your code is elegant and cool, kudos.

Thanks,
Charlie

I've already shown you how to change the number per row?
You have to be prepared to do some of the work yourself, else you will learn absolutely nothing.

 

[Charlie3]

Wow arnelgp, this is great, thank you !

Gasman, understood.

 

[Pat Hartman]

Have you tried using a subform set to display multiple columns? You have to set the column width to accommodate the widest Issue number value.

 

[spaLOGICng]

Hi.

I'm making a report for a comic book collection using only two fields, title (the title of the series of the comic book, i.e. Avengers) and issue (i.e., 1, 2, 3, etc, - the issue number of the comic book within the series title) .

I would like to display the title, skip a line, then show all of the issue numbers in rows (across then down).

When the issues within a title are all displayed, I would like to skip a line, print the next title, skip another line and then print all of the issues within that title, across and then down, and then keep going like that until there are no more titles.

Sample:

Avengers

103 108 121 134 154 155 156
162 167 184 189 190 191 202
206 209 211 212

Fantastic Four

111 113 114 115 117 120 121
122 123 127 129 130 134 135
137

X-Men

109 115 117 118 119 125 125
127 128 129

I'm using Access 2007

I tried using page setup/columns. That prints everything out in rows including the title.

In a nutshell, I haven't been able to get blank lines displayed around the title when it changes, the title field is mixed into columns with the issue numbers.

I've tried searching online and in the doc but haven't found an answer.

Thanks for any help you can provide.

Charlie

Hi Charlie,

You want an Parent Report Sub Report arrangement.

The Parent Report will have your Titles., placed in the Detail Section

Your Sub Report will have the Series. you will add Group to the Report for the Comic Book ID, and set the Header Visible Property to false.

Next you will add the Series to Left Top Most position in the Detail Section, then go to then Page Setup Tab on the Ribbon and click the Columns Button. Change the Number of Columns to what ever you like, I have set it to three. This should answer your question.

 

[Charlie3]

Hi All. Thanks very much for your input. This request has been resolved, arnelgp helped me set up a report and sub-report that gives me exactly what I need. Best to all, this was a great experience. - Charlie