Record too Large Message

[Lisa]

I have read many of the other posts on here regarding the issue I am
having. I still can't seem to figure this out.

I have a rather large database I am creating. I have 4 separate
tables that contain the fields to certain questions that are being
asked. Most of these are text fields with 250 characters set and they
use a lookup from a query to populate the possible responses. These
tables all link together for one patient record. As I enter
information for one particular patient it seems there is too much info
selected on them depending upon the size of the answer/selection. Why
is this occurring? I can't use memo fields for the majority of my
database because I have drop down boxes that show all of the possible
selections/answers, which these are set up in the query.

Any ideas?

 

[Douglas J. Steele]

Access has a record limit of 2000 bytes. However, if you've got the
questions already stored in tables, why are you storing them in the
individual records? Simply store the question number in the record, and
you'll take far less room.