Solved

is there a way to autosize an access report field?

Posted on 2008-10-27
3
822 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

734 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