how do I print

[keepout]

I use access for a grocery shopping list.
it's now expanded to about 80 items. I'd like to be able to read the list, but
it's so long now that the type is about 3 point.
What I'd like to do is print the list in 2 columns, and if it ever gets to this
size of type in 2 columns, I'd like to make more columns as necessary.

I tried just about every possible combo I could, but best I could come upwith
was it splitting the stuff into several pages. Not necessary. 2-3 columnson 1
page would be fine [better].

 

[Guest]

It sounds like you might be printing straight from the table? To get column
options you will need to create a report. An Autoreport: Columnar will do.
Then go into your File menu, Page Setup, Columns tab. Make your changes there.

Hope this helps

 

[keepout]

It sounds like you might be printing straight from the table? To get column
options you will need to create a report. An Autoreport: Columnar will do.
Then go into your File menu, Page Setup, Columns tab. Make your changes there.

Hope this helps

I use access for a grocery shopping list.
it's now expanded to about 80 items. I'd like to be able to read the list, but
it's so long now that the type is about 3 point.
What I'd like to do is print the list in 2 columns, and if it ever gets to this
size of type in 2 columns, I'd like to make more columns as necessary.

I tried just about every possible combo I could, but best I could comeup with
was it splitting the stuff into several pages. Not necessary. 2-3 columns on 1
page would be fine [better].

Aggghhh I'm in the wrong group. I'm doing this list in Excel.
Any help on how to do this in excel ?

 

[Tony Toews [MVP]]

Aggghhh I'm in the wrong group. I'm doing this list in Excel.
Any help on how to do this in excel ?

No, you'll have to ask in the Excel newsgroups.

<tongue in cheek>We Access folks look at Excel as an excellent tool
for data exchange with other systems and for graphing. </tongue in
cheek>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

yeah!!

No, you'll have to ask in the Excel newsgroups.

<tongue in cheek>We Access folks look at Excel as an excellent tool
for data exchange with other systems and for graphing. </tongue in
cheek>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[keepout]

No, you'll have to ask in the Excel newsgroups.

<tongue in cheek>We Access folks look at Excel as an excellent tool
for data exchange with other systems and for graphing. </tongue in
cheek>

Seems I'm not the only one that would like to print in columns with access. It
can't be done unless you use a huge VB script [for snaking], and know exactly
what sort of variables you want to change, and how much to change them..
I gave up after the 2nd page of variables.
Excel users use Word with it's built in columns function.

 

[Tony Toews [MVP]]

Seems I'm not the only one that would like to print in columns with access. It
can't be done unless you use a huge VB script [for snaking], and know exactly
what sort of variables you want to change, and how much to change them..

Access has multi column capability built in. When in report design
view click on File >> Page Setup >> Columns tab.

I gave up after the 2nd page of variables.
Excel users use Word with it's built in columns function.

<chuckle> Aha, I knew there was a use for Word.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[keepout]

Seems I'm not the only one that would like to print in columns with access. It
can't be done unless you use a huge VB script [for snaking], and know exactly
what sort of variables you want to change, and how much to change them..

Access has multi column capability built in. When in report design
view click on File >> Page Setup >> Columns tab.

I gave up after the 2nd page of variables.
Excel users use Word with it's built in columns function.

<chuckle> Aha, I knew there was a use for Word.

Again, I posted this in the WRONG NG. The problem exists in Excel.