How do I word wrap in Access?

[Guest]

I want to know 2 things:

1) How do I word wrap text in MS Access?

2) How do create catagories to put in alphabetical order?

 

[Douglas J Steele]

1) Word wrap text where?

2) Use a query with an appropriate ORDER BY clause.

 

[Guest]

It's easier to answer a question when it contains more detailed information.
1) by word wrap, I assume you're talking about a form or a report.
Right-click the control and set the 'can grow' property to 'yes'.
2) I don't understand what you're asking here. What do you mean by
'category'? are you talking about a query/table/report/form? A little more
clarification please.

HTH

 

[Guest]

I have Created a table of "Contacts Management". In this table, I have a
notes column that is too wide when I print. I also have about 6 other columns
that print on one page, but the notes column prints on a totally different
page.
What I mean by a catagory is I have different types of business that we are
using and I would like to put them all under their own catagory, headings
Such As:
Drywall- names of those companies
Painting- names of those companies
Flooring- names of those companies
ETC....

 

[Guest]

I would like to word wrap in my notes column only so that all of my columns
will print out on one page...
Do I have to type in the ORDER BY clause?

 

[Rick B]

You don't print a table. You print a report.

Build a report and use the appropriate controls and size them the way you'd
like.

Tables are buckets to store the data. They are not user interfaces. You
should not be working in the tables.

 

[Guest]

Thank You, Rick that really did explain alot.

You don't print a table. You print a report.

Build a report and use the appropriate controls and size them the way you'd
like.

Tables are buckets to store the data. They are not user interfaces. You
should not be working in the tables.