Re: Memo field Truncated

From: Unicorn (unicorn_at_somewhere.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 19:12:05 +0930

Simmy, do you have a Distinct keyword in there by any chance? Distinct is
the usual culprit in having memo fields turn into 255 character text fields
in a query.

Matt

"Simmy" <tbssimmy@msn.com> wrote in message
news:OXcGP8OtEHA.1040@TK2MSFTNGP10.phx.gbl...
> I am working on a VB6 Sp6 app with DAO 3.6 and am querying an Access 2000
> backend database.
> I am running a query that has tables and a union query joined together. My
> problem is that when I get the results of my query the memo fields only
have
> 255 charatcers of good data, the rest is junk. In Access the query runs
fine
> and returns all of the data. Based on a MS KB article and newsgroup
searches
> I have changed the union query to use union all and the main select query
> doesn't use distinct.
>
> Any ideas?
>
> Thanks
> Simmy
>
>

Relevant Pages

  • Re: Memo field only returns 255 characters
    ... My Source Query gets all the memo fields in their ... User 1's Entry ... The union query cuts off the fields at 255 characters. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Merging content from access
    ... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
    (microsoft.public.word.docmanagement)
  • Re: Memo field truncated in report if report contains sorting and grouping
    ... The original query included calculations as ... queries, one for all text and memo fields, one for all ... together in final query to be used in report. ... >sorting on the field, ...
    (microsoft.public.access.reports)
  • Re: Data in table (Memo field) not getting into Queries
    ... Memo fields will be truncated if ... -- You use a UNION query. ... underlines and every field has a different amount of data coming across. ...
    (microsoft.public.access.queries)
  • Re: Data Entry Mode
    ... All my memo fields for data entry but may be in a query used to supply other ... I have more which right now are truncating down to 255 characters after I ...
    (microsoft.public.access.forms)
Loading