Link to home
Start Free TrialLog in
Avatar of Mike Caldwell
Mike CaldwellFlag for United States of America

asked on

How to word-wrap a text field in an Access 2007 report?

One of the fields in an Access 2007 database (which is actually a link to an Excel CSV file, the CSV file being exported from an accounting program) contains text which can be a variable length.  "Can grow" doesn't seem to expand the field vertically so that the text can word wrap within the box.I'd like to field to just grow vertically so that there is room for all of the text.  Right now it is being truncated at the fiexed width of the box.  Usine Design mode.
Avatar of Mike Caldwell
Mike Caldwell
Flag of United States of America image

ASKER

MORE INFO:  I have other reports that do this just fine.  Even in this current report, so other fields grow/word wrap just fine.  But this one text field (it is the last one on the page; right hand side) does not.  Oddly, when I print, the problematic field puts out leading quotation marks, then how ever many characters will fill the field width.  Looking closely, it appears that it is actually trying to use the rest of the field data, but it is line feed, carriage returned, and just jammed into a very slim slice at the left margin.  Both the field that works and the one that does not are text data type and tagged as "can grow".  They are also both text in the CSV file.
Avatar of Jeffrey Coachman
old_mike,

If you move this so it is not at the bottom, does it wrap OK?

JeffCoachman
No.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No and no.

Linked.  I have a cell phone (WINCE 6.0 based) that tracks my billable hours.  When I sync it puts exports to a CSV file.  I have a static file name and location so that I can author Access reports that pick up the file and spit out my billings.
old_mike,

?
No and No to which of my questions?

You never metioned anything about Cell phones, WINCE, or Syncing in your original post.

You will have to post a sample of this Database, along with the CSV file, in order for me to make any determinations.

JeffCoachman