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

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

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 12:48:48 -0700

On Tue, 30 Mar 2004 09:27:23 -0800, "Magpie1"
<anonymous@discussions.microsoft.com> wrote:

>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?

ummm... A Memo field does not HAVE a default size!

I suspect that this is actually a Text field, not a Memo field. To
change it you must open the Table (not the query) in design view;
check the data type of the field, and if it's not Memo, change it to
Memo. Compact the database afterward if there is already data in the
table since Access will have to rebuild the table.

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

Relevant Pages

  • Re: problem importing access field into mssql
    ... According to the Access help a memo field can store up to ... Try changing the SQL Server datatype ... >the original field is a memo field which im trying to ...
    (microsoft.public.sqlserver.server)
  • Re: ms access quirey question
    ... Use a Text data type to store data such as names, addresses, and any ... A Text field can store up to 255 characters, ... Use the Memo data type if you need to store more than 255 characters. ... A Memo field can store up to 64,000 characters. ...
    (comp.lang.java.programmer)
  • Re: Need a larger data type than string
    ... Another alternative, besides using the Memo field, would be to write the ... statement and I need a larger data type to hold the INSERT/UPDATE ... Does anyone know how I can get this to handle more than 255 characters? ... The String data type in VBA is able to hold up to approximately 2 billion ...
    (microsoft.public.access.modulesdaovba)
  • Re: ms access quirey question
    ... Use a Text data type to store data such as names, addresses, and any ... A Text field can store up to 255 characters, ... Use the Memo data type if you need to store more than 255 characters. ... A Memo field can store up to 64,000 characters. ...
    (comp.lang.java.programmer)
  • Re: DAO Question
    ... dbMemo is actually the data type and it's Access database. ... Next liFt ... You should be able to assign Megs of data to a Memo field if you want to. ... Second, if you want to use the ApppendChunk loop, try adding ...
    (comp.lang.basic.visual.misc)