Displaying a memo field in a report.

C

Cramnoregreb

I have designed a data base for a college project and am having trouble with a report. I have a field that started out as a text field, but I have since changed it to a memo field because I needed to enter more than 255 characters.

The problem that I am having is: When I run a report that contains this field, it only displays 255 characters. I have tried removing the field from the report design and rentering it, I've done the same to the query that the report is sourced to, I've even tried creating a report that contains only this field. Each time it displays only 255 characters

Thanks in advance for any assistance
 
D

Duane Hookom

Do you see more than 255 characters in the datasheet view of the report's
recordsource? I expect your query might have phrases like "GROUP BY",
"UNION", "DISTINCT", or "DISTINCTROW". Other causes are not allowing the
control and/or section to grow and setting a format property on the text
box.

--
Duane Hookom
MS Access MVP


Cramnoregreb said:
I have designed a data base for a college project and am having trouble
Click to expand...
with a report. I have a field that started out as a text field, but I have
since changed it to a memo field because I needed to enter more than 255
characters.
The problem that I am having is: When I run a report that contains this
Click to expand...
field, it only displays 255 characters. I have tried removing the field from
the report design and rentering it, I've done the same to the query that the
report is sourced to, I've even tried creating a report that contains only
this field. Each time it displays only 255 characters.
 
Top