want to create a note field in access

[muddasirmunir]

i am using access database

now i have a table there is one out of which one field i want to add which is "notes" or "detail" about the
product , the notes/detail may be upto 500 characters now access only
allow us to enter max 255 character in a field now how can store
notes in acceess

[mshmyob]

Make it a MEMO field.

i am using access database

now i have a table there is one out of which one field i want to add which is "notes" or "detail" about the
product , the notes/detail may be upto 500 characters now access only
allow us to enter max 255 character in a field now how can store
notes in acceess

[missinglinq]

Memo fields are designed specifically for this purpose! The one thing to remember about memo fields, though, is that they are designed for use by human eyes only! You can view them in a form, or print them out, in their totality, but do not store any information in them that you will need to search, sort or in any other way manipulate! They are not suited for this purpose and will cause all kinds of problems if you try to force them to do so. With a 500 character requirement, if you have any idea that you may need to do any of these things, you may be better off having two comment fields that are defined as text instead of memo.

Linq ;0)>