Sorting Memos?

[Carlina]

I have a database for lecturer evaluations and in it I have a Comment field
that is a memo. In my report, I want to print all the comments, however some
students didn't put comments therefore when the report prints there are gaps
in between comments. I want to be able to have access just print the comment
records that actually have comments.

 

[KARL DEWEY]

You can not sort a memo but you can sort on the Left([YourMemo], 255)
characters.You can use criteria -- Is Not Null Or >""

 

[Armen Stein]

I have a database for lecturer evaluations and in it I have a Comment field
that is a memo. In my report, I want to print all the comments, however some
students didn't put comments therefore when the report prints there are gaps
in between comments. I want to be able to have access just print the comment
records that actually have comments.

Look at the Can Shrink property of the comment fields on the report.
If you set it to Yes, and also that the whole section of the report
has Can Shrink set to yes, then the comment fields will shrink if they
are empty.

Note that Can Shrink won't work if controls on your report overlap or
are side-by-side.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com