Part of the data is lost from a memo field when run through a quer

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

Guest

Microsoft Access 2000 Ver 9 - I have a memo field to allow large amounts of
text to be entered. However, when I run it through more than one query the
field size automatically reduces to what appears to be 250 characters, thus
losing the end of the field. Any ideas? I have had a search round for
properties and settings but with no success.
 
Dodgem said:
Microsoft Access 2000 Ver 9 - I have a memo field to allow large
amounts of text to be entered. However, when I run it through more
than one query the field size automatically reduces to what appears
to be 250 characters, thus losing the end of the field. Any ideas? I
have had a search round for properties and settings but with no
success.
Click to expand...

If you apply formatting, use Group By, or have DISTINCT in your query then they
are truncated to 255 characters.
 
Thanks, that has been a great help. A pity it isn't made clear in Access. It
would have saved me a lot of multiple field tables in the past.
 
Dodgem said:
Thanks, that has been a great help. A pity it isn't made clear in
Access. It would have saved me a lot of multiple field tables in the
past.
Click to expand...

Yep, in Access 97 you would have gotten error messages when attempting to do
any of those things in a query in which case you could CHOOSE to work around
them by using Left(MemoField, 255). In Access 2000 Microsoft decided it
would be better to just truncate the field for you without saying anything.
The amount on Newsgroup activity caused by that one change is huge.
 
Back
Top