Access library problems

[kingston9999]

Hi All,
I am using M/S Office 2002 and have built a database for my wife's professional library. However, I wish to include a comprehensive index for each book for her to search for any subjects. Frankly, 255 characters is just not enough. I need to increase the amount of characters for this in each form.
Any ideas on how I might go about this?


Thanking you all in anticipation.........
Kingston9999

[ConneXionLost]

Hi kngston9999,

If you're referring to the amount of text you can put into a single text field, then all you need to do is change the data type of the field to "Memo" instead of "Text". This is done in table design mode and is found in the field properties.

Number of characters in a Text field: 255

Number of characters in a Memo field: 65,535 (when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically)

Cheers,