Solved

is there a way to autosize an access report field?

Posted on 2008-10-27
3
811 Views
Last Modified: 2013-11-28
Hello! I have a report in access with a field (actually several fields) that are bound to memo fields that vary in length... I don't know if this is at all possible, but I'm just curious - is there a way to make the fields on the report "flexible" to accomodate how ever much text is in the memo field?
0
Comment
Question by:jpomerantz
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 22816602
When you create a box on your report for a memo field, you use a text box. Make it small (0.5 cm high) and then set the "Can Grow" propert to Yes. It will grow to accommodate the data that is supplied.


Kelvin
0
 

Author Closing Comment

by:jpomerantz
ID: 31510513
awesome!!! works like a charm :-) thank you so so so much!!!
0
 

Author Comment

by:jpomerantz
ID: 22825626
Just wondering... is there a way to do this on a Form as well?? it does not seem to work the same...
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now