Are you an Access user?  Then you'll value this Trainer Tip on how to to allow Text or Memo fields in Access reports to increase in size if the data is larger than the report display field, or to eliminate space if the field is blank.  

Whether you're managing simple data or creating advanced report designs, you'll find a classroom day spent at Full Circle will allow you to effectively use Access as a powerful database tool.

For Our Microsoft Access users...

Did you ever notice that when you print an Access report, some of the text is missing from variable-length fields (e.g., a text or memo field)? If there is too much text to display in the text box, the text is truncated (cut off). 

Instead of resizing the control to be a set length, you can set the Can Grow property to "Yes" and the text box will expand vertically depending on the contents of the field for each record.

Data that is shorter than the defined size of a text control will result in Access printing blank lines.  To eliminate the extra space, use the Can Shrink property.

• In Design view, right-click the text control you want to resize, and select Properties.
• On the Format tab, click Can Grow, and select Yes from the drop-down list (that will allow your field to expand).
• On the Format tab, click Can Shrink, and select Yes from the drop-down list (that will close up any extra space if the field is blank). 

_____________________________________________________________

Take an upcoming Access Class to learn more...