Memo field problem

[M Stanley]

I have a report with a Memo field. For some reason this truncates if there
is a large amount of data (> about 100 characters). I have set CanGrow &
CanShrink to Yes. Also the Detail section has CanGro & Can Shrink set to
Yes.

I made a quickie report with just three fields and this report shows all of
the data OK. I have compared each reports properties side by side and still
don't see the problem.

Anyone have any ideas?

 

[Douglas J. Steele]

Are you using any functions on the field? What about formatting?

Having said that, though, the problems should occur at greater than 255
characters, not 100.

 

[Guest]

Is the field agains another field? IF so try giving it more space to grow.

 

[M Stanley]

No special formatting and no functions connected. What is the problem of >
255. (haven't counted the chars. -- maybe 255+)

 

[M Stanley]

Thanks - I already tried that and it is on a line by itself. The weird thing
is that the test report I threw together has another Memo field right next
to it and both of them grow as necessary.

 

[Douglas J. Steele]

Certain actions have the effect of converting a Memo field to a Text field
(which is limited to 255 characters). Are you sorting on the field? (that's
another of the actions)

 

[M Stanley]

Not sorting on the field.

Certain actions have the effect of converting a Memo field to a Text field
(which is limited to 255 characters). Are you sorting on the field?
(that's another of the actions)

 

[M Stanley]

I changed the record source to a dlookup() instead of just a field in the
query and now it loads all data! Might be one worth remembering, guys.