Survey database. Storing memo data

[Jesper F]

I have a database normalized as Duane Hookom's "At Your
Survey".
Now I'm finding that some of the data I'm using are long
text strings longer than 255 characters.

The answer table only has a 255 char text field.

Does anyone have an idea as to how is can be made possible
to store longer text strings in some way in this kind of
setup?

 

[Douglas J. Steele]

Change the text field to a memo.

 

[Duane Hookom]

I have also seen modifications that create a separate table with a memo
field or an additional memo field added to the responses table. Users could
double-click the response combo box to open and edit a form with the memo
field.

 

[Jesper F]

I have also seen modifications that create a separate
table with a memo

field or an additional memo field added to the responses table. Users could
double-click the response combo box to open and edit a form with the memo
field.

Thanks. I'm reluctant to change the text field to a memo
field as I'm affraid it'll create a lot of overhead?

I'll think I'll try to add a memo field to the responses
table and then figure out a way to get the answer into
the memofield instead of the text field in case is a memo
answer.

I'm using a temp table and custom forms for each
questionaire. So I had the idea of putting in say 10 text
records(255) in the questionaire questions but only show
one large undbound text box on the form. And then on
submitting answers code would break up the long answer
into lengths that would fit in the text fields. That's
probably too much out there and prone to errors.

Thanks a lot for your help.

 

[Jessestonecedar]

try setting up a one to many relationship as in one record per sentence and
multiple sentences per paragraph concepts.

Rich