How can I override 'Memo' field size default to make it larger??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Magpie1 (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 09:27:23 -0800

How can I override the 'Memo' field size 255 char default
to the 65,535 char that the MS Access Help says it can
contain? I need enough space to contain long notes and
medical reports and 250 char is not enough. Help tells me
to go to 'tools' then 'options'then 'Tables/Quesries' and
change the number in the 'default field sizes' box. It
will let me type in any number I want but when I click
on 'apply' a message pops up stating: 'The setting for the
FieldSize property must be from 0 through 255'.
HELP!!!!!

Relevant Pages

  • Re: Inherited explained
    ... Justus J. wrote: ... procedure DoSomething; override; ... procedure SomethingElse(C: Char); ... us in a continuous stampede of patriotic fervor - with the cry ...
    (comp.lang.pascal.delphi.misc)
  • Re: Iterating over a String
    ... for (char category: categories) ... public static void main{ ...
    (comp.lang.java.help)
  • Re: email body getting truncated
    ... I confirmed the message text is coming from a field that is set to MEMO ... datatype. ... Just the first 255 char get copied into the email body everything else is ... John W. Vinson ...
    (microsoft.public.access.forms)
  • Re: Customized IntegerTextBox problem
    ... > a) If I override onTextChanged(), the method is called for every char ... stopping the control from losing focus if the input is invalid. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Text into Access
    ... Paul, ... I think I could use a hint about the schemas you've pointed me to. ... Col5=F5 Char Width 255 ... Col13=QUESTION Memo ...
    (microsoft.public.dotnet.languages.vb)