Entire text doesn't show

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

Guest

I have a query that had been transfered into a table and from there I have taken that information and madea report. there is a section where I have remarks. I have changed it to be in memo format so I can have a larger amount of characters; however, when I look at the report it doesn't show all of the text that I had typed in, it gets cut off. There are only about 250 charaters so I am wondering why this is happening. When it is set to memo it says that I can have somewhere around 65,000 characters. I can't figure out how to fix this problem. PLease help

Thanks
Kelli
 
Access shows only the first 255 characters if it is forced to compare the
memo field between records, or to group on the field.

If your query contains a GROUP BY, change the "Group By" in the Total row
under the memo field to "First" in query design view.

If it contains a DISTINCT or DISTINCTROW, remove that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kmccann said:
I have a query that had been transfered into a table and from there I have
Click to expand...
taken that information and madea report. there is a section where I have
remarks. I have changed it to be in memo format so I can have a larger
amount of characters; however, when I look at the report it doesn't show all
of the text that I had typed in, it gets cut off. There are only about 250
charaters so I am wondering why this is happening. When it is set to memo it
says that I can have somewhere around 65,000 characters. I can't figure out
how to fix this problem. PLease help.
 
I changed the Group By to First in my query, but then when I went and opened my report it asked for my remarks (which is the section I changed) and I could type in there but then when I hit okay it showed that remark in every part of my report instead of showing different things for each part (if that makes sense) I need the remarks in my report to be what I typed in the query and they different for every line. Any more suggestions

Thanks
Kelli
 
Hi Kelli.

When you use First in the Total row of the query, it changes the name of the
output field. You need to change the name in the report as well.

Assuming a field named "Comments", the query will output FirstOfComments.
1. Open your report in design view.

2. Right-click the Comments field, and choose Properties.

3. Change the Control Source property (on the Data tab) to:
FirstOfComments.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kmccann said:
I changed the Group By to First in my query, but then when I went and
Click to expand...
opened my report it asked for my remarks (which is the section I changed)
and I could type in there but then when I hit okay it showed that remark in
every part of my report instead of showing different things for each part
(if that makes sense) I need the remarks in my report to be what I typed in
the query and they different for every line. Any more suggestions?
 
Back
Top