missing text

A

access novice

For some reason when I go to the query or report that was run some text
disappears. I have verified that the text is complete in both the table and
the form. What can I do to have all the text show up in my queries and
reports?
 
J

John W. Vinson

On Wed, 27 Jan 2010 14:02:01 -0800, access novice <access
For some reason when I go to the query or report that was run some text
disappears. I have verified that the text is complete in both the table and
the form. What can I do to have all the text show up in my queries and
reports?
Click to expand...

I would guess, correct the error in the query. If you would like help doing so
please post the SQL view of the query, and indicate what you mean by "run",
and which field appears to be losing data.
 
T

Tom van Stiphout

On Wed, 27 Jan 2010 14:02:01 -0800, access novice <access
[email protected]> wrote:

Big speculation follows, because as John mentions you are not
providing enough detail. So here goes: you have a Memo field and in
your query you're using some VBA functions that effectively limit the
size of this column to 255 chars.

-Tom.
Microsoft Access MVP
 
Top