By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,397 Members | 1,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,397 IT Pros & Developers. It's quick & easy.

want to create a note field in access

100+
P: 284
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
Feb 21 '08 #1
Share this Question
Share on Google+
2 Replies


mshmyob
Expert 100+
P: 904
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
Feb 21 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
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)>
Feb 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.