Access 2003 Help Needed!

[Dana]

Hello,
I work at a university and we are trying to input all the professor's
research titles into a database for students who want to do a special project
with that professor. We need to print off these research ideas for various
uses.

Whenever I try to print them off, if there is more words than can fit on a
page, it just cuts them off. Can I somehow tell the program to text wrap?
Also if the titles are really long, Access won't let me enter over a certain
amount of characters - can I change that as well?

thanks
Dana

 

[Scott McDaniel]

Hello,
I work at a university and we are trying to input all the professor's
research titles into a database for students who want to do a special project
with that professor. We need to print off these research ideas for various
uses.

Whenever I try to print them off, if there is more words than can fit on a
page, it just cuts them off. Can I somehow tell the program to text wrap?

Assuming you've built a Report, you can set the Control you're using to display the title to Can Grow = True ... this
should allow the control to grow to fit whatever text you place in there.

Also if the titles are really long, Access won't let me enter over a certain
amount of characters - can I change that as well?

The maximum number of Characters for a Text field is 255. If your titles are longer than that, use Memo fields (which
are maxed at around 65k characters if entered through the UI, and 1 gb if entered programatically).

thanks
Dana

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Dana]

Thanks Scott for the info - no indication on whether or not I can wrap the
text that I have already input into a text field? Can I wrap the text in the
memo fields?

Dana