PC Review


Reply
Thread Tools Rate Thread

Access 2003 Help Needed!

 
 
Dana
Guest
Posts: n/a
 
      8th Jan 2008
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
 
Reply With Quote
 
 
 
 
Scott McDaniel
Guest
Posts: n/a
 
      8th Jan 2008
On Tue, 8 Jan 2008 08:30:00 -0800, Dana <(E-Mail Removed)> wrote:

>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
 
Reply With Quote
 
Dana
Guest
Posts: n/a
 
      8th Jan 2008
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

"Scott McDaniel" wrote:

> On Tue, 8 Jan 2008 08:30:00 -0800, Dana <(E-Mail Removed)> wrote:
>
> >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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help needed saving access 2003 reports as individual files robert Microsoft Access 1 6th Jan 2009 10:24 PM
NEEDED: MS ACCESS 2003 Consultant mpmason19 Microsoft Access 7 18th Apr 2007 05:47 PM
Access 2003 template needed if available =?Utf-8?B?SmFzZTRub3c=?= Microsoft Access 0 7th Mar 2007 05:08 PM
Validation Rule needed Access 2003 =?Utf-8?B?TWlrZQ==?= Microsoft Access 3 3rd Apr 2006 11:11 PM
Help Needed: GPO needed to deny user logged on locally to net access Anonymous Microsoft Windows 2000 Group Policy 1 21st Jan 2004 10:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:39 PM.