Need help, not sure if I should use a Word document linked to a re

[Deb H]

I have a database that has about 8 questions that folks will fill out in an
essay style manner, some will get quite long. I would use a memo field
normally, but not sure if that's the best solution. Would you advise me to
link a word document to each record? Or would you suggest using a memo
field? I have to be able to print this with each record. I'm really not
sure of this best solution here.

 

[Pat Hartman\(MVP\)]

Use a memo field to store each answer. Hopefully, your tables are properly
normalized. That means that your questions/answers belong in a separate
table so that each question/answer is a separate row. If you currently have
all 8 questions/answers in a single row, fixing the table schema before you
move on would be a good idea.

 

[John Vinson]

I have a database that has about 8 questions that folks will fill out in an
essay style manner, some will get quite long. I would use a memo field
normally, but not sure if that's the best solution. Would you advise me to
link a word document to each record? Or would you suggest using a memo
field? I have to be able to print this with each record. I'm really not
sure of this best solution here.

Unless they'll be writing novels, a memo field should be fine: 65536
characters, about twenty pages typically.

You can link to Word documents, but the programming gets a bit
hairier.

John W. Vinson[MVP]