Re: Problem returing data from Memo fields when queried in Access
- From: "Chaim" <Chaim@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 08:42:04 -0700
Also, try searching on 'memo field truncation' in 'MSDN Newsgroups'. There
are quite a number of similar questions with answers.
"Marshall Barton" wrote:
> Steve Hankin <Steve Hankin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >When I use a date-parameterised query in Access 2000, the data returned from
> >my Memo-type fields in the queried table is truncated to 255 chars.
> >
> >Is there a way to fix this so that all of the characters held in the memo
> >fields can be returned by the query and subsequently displayed in a report?
>
>
> Using a parameter should have no effect on memo field
> truncation. The usual cause of truncation is the use of the
> memo field in a Group By clause. A UNION query and a few
> other things will also cause it.
>
> We need more details to pin it down. For instance, if you
> have specified the query field's Format property, or are
> displaying the memo field in a form/report text box with its
> Format property, then it will be truncated at display time.
>
> If those clues don't get you going in the right direction,
> post back with the query's SQL statement and an explanation
> of how you are viewing the memo field.
>
> --
> Marsh
> MVP [MS Access]
>
.
- References:
- Problem returing data from Memo fields when queried in Access 2000
- From: Steve Hankin
- Re: Problem returing data from Memo fields when queried in Access 2000
- From: Marshall Barton
- Problem returing data from Memo fields when queried in Access 2000
- Prev by Date: Re: Problem returing data from Memo fields when queried in Access 2000
- Next by Date: Re: Get 1 total from repeating values
- Previous by thread: Re: Problem returing data from Memo fields when queried in Access 2000
- Next by thread: IDENTITY INSERT
- Index(es):
Relevant Pages
|
