G
Guest
I have a field defined as a memo field. Yet, when I display it on a report,
it only prints 255 characters.
it only prints 255 characters.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Are you using the Format function on it?
G
Guest
I am not using any format.
Douglas J. Steele said:Are you using the Format function on it?
D
Douglas J. Steele
Do you have the Can Grow property set to Yes?
G
Guest
Yes!. The Can Grow property is set. If I display the field on a form, all the
text is displayed. However, it only appears to print 255 characters on a
report.
text is displayed. However, it only appears to print 255 characters on a
report.
R
Rick Brandt
zoomobile said:Yes!. The Can Grow property is set. If I display the field on a form, all the
text is displayed. However, it only appears to print 255 characters on a
report.
Look at the RecordSource (table or query) of the report directly. Do you see
all the characters there?
G
Guest
Rick,
I see a little progress. The report reads a query pulled from multiple
tables. If I look at the results of the query,my field of interest is
truncated. All the data is there in the original table. Somehow, a query may
have a limit of 255 chracters for a memo field.
I wonder if there is a way to get around it. My field of interest contains
directions to get to an address. Thanks for your help.
I see a little progress. The report reads a query pulled from multiple
tables. If I look at the results of the query,my field of interest is
truncated. All the data is there in the original table. Somehow, a query may
have a limit of 255 chracters for a memo field.
I wonder if there is a way to get around it. My field of interest contains
directions to get to an address. Thanks for your help.
R
Rick Brandt
zoomobile said:Rick,
I see a little progress. The report reads a query pulled from multiple
tables. If I look at the results of the query,my field of interest is
truncated. All the data is there in the original table. Somehow, a query may
have a limit of 255 chracters for a memo field.
I wonder if there is a way to get around it. My field of interest contains
directions to get to an address. Thanks for your help.
If your query is grouping on the memo or is using DISTINCT then the memo will be
truncated. Also make sure there is no format being applied to the field by the
query.
D
Douglas J. Steele
Rick Brandt said:If your query is grouping on the memo or is using DISTINCT then the memo
will be truncated. Also make sure there is no format being applied to the
field by the query.
For that matter, if he's using UNION (rather than UNION ALL), I believe the
memo field is treated like a text field.
D
Duane Hookom
Maybe Zoomobile could provide the SQL view of the report's record source....