Welcome to SPN

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

Sign Up Now!

Memo box

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

Tags:
  1. Blodnik

    Blodnik
    Expand Collapse
    Guest

    I have an old database (originally Access 95, now Access 2003) that has a
    text box I want to convert to a memo box, but the 'change to' menu does not
    include the 'memo' option. How can i change the field so I can add more text
    without affecting the old records (>25000)?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Beyond Chamkaur: Wars, Battles & Memories Sikh Sikhi Sikhism Dec 23, 2015
    Memorial to the remarkable Sikh soldiers of WWI Sikh Personalities Oct 31, 2015
    Narayanjot Kaur Aka Spnadmin Some Memories Intellectual Articles Apr 28, 2015
    Gurus Commemorating The Painting Of Guru Gobind Singh Ji By Bhagat Singh Bedi History of Sikhism Apr 15, 2015
    UK UK Sikh Biker Group ‘Humbled’ to be on Lee Rigby Memorial Ride to Woolwich Barracks in Ilford Breaking News May 24, 2014

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Change to? You can't change it in your form, you would have to change the
    actual data type in the table.

    Go to the table design view and change the data type to Memo, then adjust
    any forms that you feel need to be adjusted.

    --
    Rick B



    "Blodnik" <Blodnik@discussions.microsoft.com> wrote in message
    news:53B5C949-B177-4B2E-B56B-5A961CE4E066@microsoft.com...
    >I have an old database (originally Access 95, now Access 2003) that has a
    > text box I want to convert to a memo box, but the 'change to' menu does
    > not
    > include the 'memo' option. How can i change the field so I can add more
    > text
    > without affecting the old records (>25000)?
     
  4. SuzyQ

    SuzyQ
    Expand Collapse
    Guest

    The design of a table does not have a "Change to" menu option, that is part
    of the design of a form or a report. Changing the type there will not allow
    you to enter any more data into the table. You need to change the data type
    of the table itself. To do that go to the tables section of the database
    window. Find the table you want to change, open it in design mode, and use
    the drop down box under data type to change to a menu data type.

    "Blodnik" wrote:

    > I have an old database (originally Access 95, now Access 2003) that has a
    > text box I want to convert to a memo box, but the 'change to' menu does not
    > include the 'memo' option. How can i change the field so I can add more text
    > without affecting the old records (>25000)?
     
  5. Blodnik

    Blodnik
    Expand Collapse
    Guest

    Many thanks to both of you, problem solved, I shall stick to my day job in
    future!

    "SuzyQ" wrote:

    > The design of a table does not have a "Change to" menu option, that is part
    > of the design of a form or a report. Changing the type there will not allow
    > you to enter any more data into the table. You need to change the data type
    > of the table itself. To do that go to the tables section of the database
    > window. Find the table you want to change, open it in design mode, and use
    > the drop down box under data type to change to a menu data type.
    >
    > "Blodnik" wrote:
    >
    > > I have an old database (originally Access 95, now Access 2003) that has a
    > > text box I want to convert to a memo box, but the 'change to' menu does not
    > > include the 'memo' option. How can i change the field so I can add more text
    > > without affecting the old records (>25000)?
     

Share This Page