Running Query on memo field - character limit

[Becky N]

Hello,

I'm using Access 2003 and I have a master report made up of two subreports
that are linked together by record number. The one subreport pulls data from
a table that contains only 3 fields--record number, date, and note. The note
field is a memo field. The users of this database have requested to be able
to pull the master report but only show notes after a certain date of their
choosing. Therefore, I created a query based off of my note table (the one
with the 3 fields) and it will pull a note with any date greater than the
date they input into a prompt. However, when the master report comes up once
they do this the note field I believe is now converted to a text field and
only holds 255 characters. Some of my data in the field is being cut off now.

Is there anyway I can accomplish my same goal while preserving the memo
formatting for my notes field?

Thanks for your help!

Becky

 

[Keven Denen]

Hello,

I'm using Access 2003 and I have a master report made up of two subreports
that are linked together by record number. The one subreport pulls data from
a table that contains only 3 fields--record number, date, and note. The note
field is a memo field. The users of this database have requested to be able
to pull the master report but only show notes after a certain date of their
choosing. Therefore, I created a query based off of my note table (the one
with the 3 fields) and it will pull a note with any date greater than the
date they input into a prompt. However, when the master report comes up once
they do this the note field I believe is now converted to a text field and
only holds 255 characters. Some of my data in the field is being cut off now.

Is there anyway I can accomplish my same goal while preserving the memo
formatting for my notes field?

Thanks for your help!

Becky

Check out this page, does a good job of explaining the issue.

http://allenbrowne.com/ser-63.html

Keven Denen

 

[John Spencer]

It would help if you showed the SQL of the query you are using.

Memo fields get truncated in several instances (these come immediately to mind)
== Use a distinct clause
== Use aggregates
== Apply a format to the memo field


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[silva]

Another thought is maybe the field on the report isn't large enough to hol
all the text. In the Properties box, if you haven't done so already, you
should set the "Can Grow" property to Yes (supposing all other fields are
either above or below that field). Maybe it is a Memo-to-Text Box conversion
issue, but I have found this to solve the problem if it isn't.


--Silva

 

[Becky N]

Thanks John! I knew it had to be something so simple. I had the group by
function on (I didn't even think about that). Just a click of a button and
it's fixed.

I feel pretty silly now knowing all that time I spent trying to fix it all.