missing data
in [Reports]
|
Prev: Report has 126 pages and take forever to run
Next: Access 2007 Report shows multiple rows, query shows single row
From: Anna on 2 Nov 2009 13:50 Hello, I have several memo fields in one table. When I look at the report for a single record in this table, I notice that only some of the information will print. I realize that I can adjust the field text box size on the report, but what I would like is some expression or command to print all information in the memo field without the end user having to adjust the text box size. The entries in the memo fields are lengthy and will vary per record, so adjusting the text box size on each report is not practical. Any help would be appreciated. Thank you. -- Anna
From: Gina Whipp on 2 Nov 2009 14:04 Anna, How about setting the Properties of the Text Box to Can Grow = Yes? Then the Text Box will self adjust to the characters within. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Anna" <Anna(a)discussions.microsoft.com> wrote in message news:D4A60C9B-813B-42B4-82C7-BA043547EBA4(a)microsoft.com... > Hello, > > I have several memo fields in one table. When I look at the report for a > single record in this table, I notice that only some of the information > will > print. I realize that I can adjust the field text box size on the report, > but what I would like is some expression or command to print all > information > in the memo field without the end user having to adjust the text box size. > The entries in the memo fields are lengthy and will vary per record, so > adjusting the text box size on each report is not practical. Any help > would > be appreciated. Thank you. > -- > Anna
From: Anna on 2 Nov 2009 16:03
Please disregard. I found the answer under "memo fields." -- Anna "Anna" wrote: > Hello, > > I have several memo fields in one table. When I look at the report for a > single record in this table, I notice that only some of the information will > print. I realize that I can adjust the field text box size on the report, > but what I would like is some expression or command to print all information > in the memo field without the end user having to adjust the text box size. > The entries in the memo fields are lengthy and will vary per record, so > adjusting the text box size on each report is not practical. Any help would > be appreciated. Thank you. > -- > Anna |