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. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    discocyst wrote:
    > 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 :)


    Change the Datatype to Memo. There are some caveats with that type. You cannot
    index it, link or group on it in queries (grouping will actually be applied to
    first 255 characters).

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. discocyst

    discocyst
    Expand Collapse
    Guest

    Thanks.. works fine now :)

    "Rick Brandt" wrote:

    > discocyst wrote:
    > > 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 :)

    >
    > Change the Datatype to Memo. There are some caveats with that type. You cannot
    > index it, link or group on it in queries (grouping will actually be applied to
    > first 255 characters).
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  5. discocyst

    discocyst
    Expand Collapse
    Guest

    Thanks.. works fine now :)

    "Rick Brandt" wrote:

    > discocyst wrote:
    > > 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 :)

    >
    > Change the Datatype to Memo. There are some caveats with that type. You cannot
    > index it, link or group on it in queries (grouping will actually be applied to
    > first 255 characters).
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     
  6. discocyst

    discocyst
    Expand Collapse
    Guest

    Thanks.. works fine now :)

    "Rick Brandt" wrote:

    > discocyst wrote:
    > > 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 :)

    >
    > Change the Datatype to Memo. There are some caveats with that type. You cannot
    > index it, link or group on it in queries (grouping will actually be applied to
    > first 255 characters).
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     

Share This Page