Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

set unlimited field size

Discussion in 'Information Technology' started by discocyst, Jul 28, 2006.

  1. discocyst

    discocyst
    Expand Collapse
    Guest

    Apologies for asking such a basic question but..
    I am having problems increasing the field size of a text box beyond 255..

    does anyone know an easy way to do this or an alternative to using a text box?

    i am trying to create an error reporting database and need to be able to
    capture quite large amounts of text.

    i'm not too hot with visual basic, but any help again would be appreciated.

    thanks :)
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Settlement Leads To Peaceful Transition At Sikh Temple Breaking News Sep 10, 2016
    Sikhi Langar-Aid - Sikhs Have Set Up A 'Langar' In The ISIS Territory of Syria To Feed Refugees Sikh Sikhi Sikhism Oct 31, 2015
    A set back or a step forward Blogs Oct 17, 2015
    USA Sikh Cartoonist Sets Out To Fight Racial Bias Breaking News Mar 9, 2015
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    The maximum field size for the Text datatype is 255. If you need more, use a
    Memo datatype which allows 64K through the interface and 1 GB
    programmatically.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "discocyst" <discocyst@discussions.microsoft.com> wrote in message
    news:C0800453-9DDA-4D84-8D9B-1341F1F31AF0@microsoft.com...
    > Apologies for asking such a basic question but..
    > I am having problems increasing the field size of a text box beyond 255..
    >
    > does anyone know an easy way to do this or an alternative to using a text

    box?
    >
    > i am trying to create an error reporting database and need to be able to
    > capture quite large amounts of text.
    >
    > i'm not too hot with visual basic, but any help again would be

    appreciated.
    >
    > thanks :)
     
  4. SusanV

    SusanV
    Expand Collapse
    Guest

    Memo fields aren't "unlimited", but will hold a LOT more.

    http://www.databasezone.com/techdocs/acclimit.html
    --
    hth,
    SusanV



    "discocyst" <discocyst@discussions.microsoft.com> wrote in message
    news:C0800453-9DDA-4D84-8D9B-1341F1F31AF0@microsoft.com...
    > Apologies for asking such a basic question but..
    > I am having problems increasing the field size of a text box beyond 255..
    >
    > does anyone know an easy way to do this or an alternative to using a text
    > box?
    >
    > i am trying to create an error reporting database and need to be able to
    > capture quite large amounts of text.
    >
    > i'm not too hot with visual basic, but any help again would be
    > appreciated.
    >
    > thanks :)
     

Share This Page