how to expand column to take lot of text

C

CONFUSED

I have opened up access but the last column which has up to 255 words in it
only shows the first few words! how can i get to print out all text in last
column?? HELP!!!!
 
B

Beetle

It *sounds* like you are viewing data directly in the table. If so, then that
is the problem. Tables are for storing data, not viewing it. You should be
viewing it in a form, with a text box large enough to accomodate all or most
of the text. Likewise, if you want to print it, you should be doing so via a
report, again with an appropriately sized text box
 
S

Stockwell43

Hi Confused,

As said by Beetle the table is for storing not viewing. Also, as for the 255
if your field is a comments box of some sort you should set the Data Type to
Memo so it will hold more. You need to create a report to view your data.
Make a simple query of the fields you want and then use the wizard to create
the report. All the information in your field will now show. However, you may
have some tweeking like if the field on the report is not stretch out enough,
go in the properties of that textbox and change Can Grow to yes.
 
Top