Multiple Columns

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

I need to have a roster print with multiple columns so it's all one one
page. How do I do that? I've done it by doing a query, copying that into
excel, and I've then copied it into word set for three columns. Works fine.
In fact I can work the columns in word, delete names, resort etc. The roster
includes typical stuff like name, Intercom #, etc. How do I do it in a
report and cut out the excel & word middlemen? All I have now is three
columns each duplicating each other (beginning with A).
 
Did you try Page Setup and setting the number of columns to three there?

That will take your one column in the Report layout and split it into three
columns when you print.
 
I had tried page setup columns and it didn't seem to work. However, after
leaving the post here I looked again. The problem was that the default
column width was so large there was no way I could get columns. I reset it
from 16.5 (???? don't ask me why it had that in there when I first looked at
it) to 3.3 and I now have columns...works fine.
 
OK, now that I have it printing in columns can I do either or both of the
following:
On a section sort I want only the first occurance in a section to actually
print the section name(ie.):
Section Name
AA Person 1 In That Section
Person 2 In That Section
BB Person 1 In That Section
Person 2 In That Section
I think the above is much more pleasing to the eye than:
AA Person 1 In That Section
AA Person 2 In That Section
BB Person 1 In That Section
BB Person 2 In That Section

Also, in the same idea as the above can I have the first occurance to be a
different color. So that these two lines:
AA Person 1 In That Section
BB Person 1 In That Section
would be different colors that the others. When I'm talking colors I mean
either text and/or text background.

In fact let's but another possibility in the mix. All the listings by
section would have a different text and or background colors. So all the
AA's would be one color and BB's another.
 
Add a textbox control and name it "txtSetColor" then set its properties as noted.
OK, I've obviously flunked this lesson. No problem with the Hide Duplicates.
BUT, although I worked a lot with queries I've hardly ever done Reports.
This is the first one where I didn't just use a wizard and be done with it.
I've never had any formal training on Access....all just trail and error. As
far as adding a new control. Are you talking about an "Active X Control"? If
you are, I didn't see a "txtsetcolor" listed.

John Spencer (MVP) said:
Hiding repeats.
Click on the Control for the Section field.
In the properties Format Tab, change the Hide Duplicates property to Yes

Different color for the first item in a section.
Add an new control (txtSetColor) to the section
Set its control source to "=1" (no quotes)
Set its Running Sum to Over group

Click on the Detail Section
In the on Format enter [Event Procedure]
Click on the three dots

In the area, enter

If Me.TxtSetColor = 1 Then
Me.ControlNameA.ForeColor = 255
<Repeat as necessary>
Else
Me.ControlNameA.ForeColor = 0
<repeat as necessary for other controls>
End if

And yes, you can do the last one also by using code in the On Format Event of
the Group to set the properties of the controls in the detail section. This
last is left as an exercise for the student.
OK, now that I have it printing in columns can I do either or both of the
following:
On a section sort I want only the first occurance in a section to actually
print the section name(ie.):
Section Name
AA Person 1 In That Section
Person 2 In That Section
BB Person 1 In That Section
Person 2 In That Section
I think the above is much more pleasing to the eye than:
AA Person 1 In That Section
AA Person 2 In That Section
BB Person 1 In That Section
BB Person 2 In That Section

Also, in the same idea as the above can I have the first occurance to be a
different color. So that these two lines:
AA Person 1 In That Section
BB Person 1 In That Section
would be different colors that the others. When I'm talking colors I mean
either text and/or text background.

In fact let's but another possibility in the mix. All the listings by
section would have a different text and or background colors. So all the
AA's would be one color and BB's another.

I had tried page setup columns and it didn't seem to work. However, after
leaving the post here I looked again. The problem was that the default
column width was so large there was no way I could get columns. I reset it
from 16.5 (???? don't ask me why it had that in there when I first looked
at
it) to 3.3 and I now have columns...works fine.


Did you try Page Setup and setting the number of columns to three there?

That will take your one column in the Report layout and split it into
three
columns when you print.

mcl wrote:

I need to have a roster print with multiple columns so it's all one
one
page. How do I do that? I've done it by doing a query, copying that
into
excel, and I've then copied it into word set for three columns. Works
fine.
In fact I can work the columns in word, delete names, resort etc. The
roster
includes typical stuff like name, Intercom #, etc. How do I do it in a
report and cut out the excel & word middlemen? All I have now is three
columns each duplicating each other (beginning with A).
Click to expand...
Click to expand...
Click to expand...
 
Back
Top