Re: memo field not show all

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 16:52:51 -0600

On Sun, 18 Jul 2004 15:27:23 -0700, "John"
<anonymous@discussions.microsoft.com> wrote:

>I have a small form with 2 combo boxes and a memo field on
>it. I select the first combo box and the second will fill
>with the filtered info based on the first. These work.
>The memo field (txtbox) is them to fill with the verbage
>based on the second combo box selection. This is where
>the problem enters. The info will display but not all of
>it. It seems to cutoff. The table says it is a memo
>type. Does any one know why this would occur? I have
>others that do not do this and they and this one are made
>the same.
>Thanks in advance for any assistance.
>*** John

If you're trying to fill the memo field by relaying its contents
through the combo box, it will NOT work - you cannot put 2 GByte (or
even 65536 bytes) of data into a Combo box column, it will truncate at
255.

How are you filling the textbox? Could you post your code?

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Relevant Pages

  • Re: memo field not show all
    ... *** John ... >>I have a small form with 2 combo boxes and a memo field ... >>with the filtered info based on the first. ... >>The memo field is them to fill with the verbage ...
    (microsoft.public.access.formscoding)
  • memo field not show all
    ... I have a small form with 2 combo boxes and a memo field on ... with the filtered info based on the first. ... *** John ...
    (microsoft.public.access.formscoding)
  • Re: Truncated memo field in query & mail merge output
    ... If the memo field is greater than 255 characters, a query based on the sql ... daughter should now be wearing bermuda shorts and flip flops to school. ... Distinct or DistinctRow will all truncate a memo field to 255 characters so ...
    (microsoft.public.access.formscoding)
  • Truncated memo field in query & mail merge output
    ... If the memo field is greater than 255 characters, a query based on the sql ... daughter should now be wearing bermuda shorts and flip flops to school. ... Distinct or DistinctRow will all truncate a memo field to 255 characters so ...
    (microsoft.public.access.formscoding)
  • Re: Using CStr on a Memo field
    ... allowed with memo fields that just internally truncate all but the ... first 255 characters automatically. ... the first 255 characters of a memo field in their report output. ... you've probably got a design error, so I'm not sure this is a ...
    (comp.databases.ms-access)