Just for the record, as terminology is important in our understanding the
problem and offering suggestions. An Access File is an MDB, or an MDE, or
an MDW, or an MDA, or (additional types added with Access 2007). We
generally do not refer to "cells" because "cells" refers to positions on a
Spreadsheet, not a database concept.
What you _described_ seems to be an Access Table, with Columns (aka Fields)
and Rows (aka Records).
I would guess, but it's not certain, that you are viewing the Table
directly, that is, in what we call "Datasheet View". And, that is the
viewing format that allows the least flexibility and opportunities for
enhancement.
If you have a Field that contains so much data that it cannot fit on a
single screen, that is almost certainly a Memo Field.
If you create a Form to display your data, instead of displaying the
datasheet, the Text Box Control created by the Form Wizard for a Tabular
Form will, by default, include a vertical scroll bar. If, for some reason,
your settings are such that it does not, then change the Form to design
view, display the Property Sheet for that Control and, in the Format tab,
set the Scroll Bars property to Vertical (and, if you'd like, you can set
the property to Both) to increase your users' flexibility. And, in design
view, you can resize your controls as big as you think is usable on your
screen.
Larry Linson
Microsoft Access MVP
<st*******@gmail.comwrote in message
news:11**********************@o11g2000prd.googlegr oups.com...
First off, I really don't know much about Access, so please bear with
me. Here's my problem. I have an Access file containing about 15
columns and 600 rows. Each cell in one of the columns contains an
email, including all the html coding. Most email have just a few
lines of actual text, but with all the html stuff (<doctype><body
bgColor></Div><Bodyetc.), it usually fills up most of the screen.
Problem is, whenever the content of a cell is too much to fit on the
screen, the overflow is simply dropped of the screen. So when I print
it, I get the first, say, 90%, and the remaining 10% is gone, instead
of appearing on the next printed page. I hope I'm making sense. I
tried exporting the file into Excel, but the result is even worse: I
only get the first few lines of each email. If anyone out there could
shed some light on this, I'd sure appreciate!
Thanks!
Daniel
