memo field maybe??

[Jean-Paul De Winter]

Hi,
I need some advise.
I work in a school and I am asked to create an access project so teachers
can enter points.
Of course some want to add some comment.
Some find it enough to write one word, some think almost writing a book is
needed.....
How should I create my table?
I thought about creating a memofield but I'm a bit puzzled:
first, when printing a report, will only entered characters be printed or
will access print a lot of empty space??
then, wil my table be hughe with all these memofields which may not have one
character in it??,

Anyway... I need your thought about how you all should solve this problem
Thanks

 

[fredg]

Hi,
I need some advise.
I work in a school and I am asked to create an access project so teachers
can enter points.
Of course some want to add some comment.
Some find it enough to write one word, some think almost writing a book is
needed.....
How should I create my table?

You can include a memo field in the table.

I thought about creating a memofield but I'm a bit puzzled:
first, when printing a report, will only entered characters be printed or
will access print a lot of empty space??

In your report, include the memo field. Make it as wide as you wish,
but just tall enough for one line. Set this memo field's CanGrow
property to Yes. Also set the Report's Detail Section CanGrow property
to Yes. The control will grow to accommodate as much text as is needed
for each record.

You may also set the control's CanShrink property to Yes. If there is
no other control on that same line and if there is no data to display,
the space will shrink as well.

then, wil my table be hughe with all these memofields which may not have one
character in it??,

Unused Field space does not take any Access memory space.

Anyway... I need your thought about how you all should solve this problem
Thanks

Have fun!