Field to Text

[joey]

I am working with an Excel spreadsheet that has a comment field and I want to
import it into Access. My issue is that the comment field can run from two
words to two sentences so sometimes the text gets truncated. Is there a way
to make a field on a Report wrap to what is entered instead of the exact text
box size.

 

[Al Campagna]

joey,
If a text control on a report varies greatly in length, set that
control's CanGrow to True.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Wayne-I-M]

To follow on from Al's good answer - also make sure that the field size (in
the table you are importing to) is big enough to take the maxiumum number of
digits to may import.
Use the properties box in the table design for that field to make sure