Column Naming Too Long

[Kaylen]

I am designing a database consists of questions as column fields in a table.
My problem is that since the coulmn fields are the the questions, the
questions are very lengthy and won't fully fit in the column headings in the
table. I tried naming the columns by numbers but then when I export the data
onto excel, I can only see the numbers as columns headers and my goal is to
be able to see the whole question in the column heading instead. Any ideas on
how to solve this problem? Thank you!

 

[John W. Vinson]

I am designing a database consists of questions as column fields in a table.

Then you are making a VERY BIG MISTAKE.

My problem is that since the coulmn fields are the the questions, the
questions are very lengthy and won't fully fit in the column headings in the
table. I tried naming the columns by numbers but then when I export the data
onto excel, I can only see the numbers as columns headers and my goal is to
be able to see the whole question in the column heading instead. Any ideas on
how to solve this problem? Thank you!

Use a normalized data structure with one question per *RECORD* rather than one
question per *FIELD*, in a table related one to many to your main table; and
use a Crosstab query with the question field as the Column Header for your
export to Excel.

 

[Kaylen]

Can you give me more detailed direction with this?

 

[John W. Vinson]

Can you give me more detailed direction with this?

There's an excellent questionnaire demo application available at
Duane Hookum's "At Your Survey":

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Also consider Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb

 

[Kaylen]

Is there a way to have a hyperlink that opens to show a specific record on a
form?