Sorting Memos?

  • Thread starter Thread starter Carlina
  • Start date Start date
C

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.
 
You can not sort a memo but you can sort on the Left([YourMemo], 255)
characters.You can use criteria -- Is Not Null Or >""
 
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.
Click to expand...

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
 
Back
Top