Displaying a memo field in a report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top