HELP ME with Cell Size.

[Miva Man]

Dear Access Expert,

Just bought M.S.Access yesterday.I have a product data
base of about 2000 products that I'm trying to type into
M.S. Access. The fields are:

Product Name, Product Part#, Unit of Issue, Price, Cost
and Description.

The problem I'm having is in the Description field. Some
of my descriptions are slightly too long and when I type
beyond a certain amount it give me an error:

"The Text is too long to be edited"

How do I change this? I have been using Excel for year and
never had such a problem.

Thank you.
Dave

 

[Bob Sullivan]

Dear Dave,

When you designate an Access field as a text data type,
the size limit is 255 characters. If it is necessary to
have the field contain more than 255 characters, make it
a memo data type. You will not be able to sort on a memo
data field, but your probably won't be sorting by product
description anyway.

Bob Sullivan
Springhouse

 

[Norman Yuan]

Besides Bob's opinion, another thing you should be aware: you, or your
database's users, are not supposed to type in data directly into tables in
Access unless the so called database is very simple, or you are the only
user and you know what you are exactly doing.

You should create forms as user interface to deal with data: inputing,
editing and viewing...