Memo box

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

 

[Rick B]

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.

 

[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.

 

[Guest]

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