Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Expand fields on access database report for only lines that need it

Posted on 2013-02-07
5
Medium Priority
?
354 Views
Last Modified: 2013-02-07
I have a report in access and some of the notes on some records have info that need to be expanded underneath them.

I know i can expand all of them and fit the info in, but then i have a report that takes up many pages. Can i expand only the ones that have too much info to fit into one line?

on the attached image you can see that BAM 2381 is cut off on the notes field. i want to that any any other that get cut off to expand underneath. BUT only the ones that need it
Untitled-picture.png
0
Comment
Question by:bignadad
[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
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 2000 total points
ID: 38864926
Set the Can Grow property for that field/control to Yes.  You must also set the Can Grow property for the report section (Detail Section) to Yes.

OM Gang
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38864928
Set the Can Grow property for that control and for the section it is in  (?detail section) to Yes.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38864996
4 Seconds!! ^&**(  (:-)
0
 
LVL 28

Expert Comment

by:omgang
ID: 38865006
peter57r, I had just read a response from you to another Q so I figured I had a chance to sneak in under your radar.  ;)

OM Gang
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38865082
No problem - I'm just getting too old to type quickly!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

604 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