Dynamic field sizes in reports

F

Fargo

I am trying to create a report that has 5 simple (small!) fields and two memo
/ text fields on each row. These text fields can either be a few words long
or lots of words long. I would like to produce a report where the next row
starts just after the previous one with no large "white" space between the
rows if there is only a small amount of text in the row and I have formatted
the text field for lots.

Is it possible to dynamically size the text boxes. I am using Access 2000.

Many Thanks
 
B

Brendan Reynolds

Set the Can Grow and Can Shrink properties of the text boxes, and of the
section (e.g. Detail) that contains them to 'Yes'.
 
F

Fargo

Excellent

Thanks for the quick response - I'd been looking at field / report
properties but miss the significance of these.

Many thanks

fargo
 
P

paulsteigel

I have an access database for keeping contact list and work branche o
various office in Vietnam. There are requirement for the output a
following:
There are a lot of missing information in a contact, sometime peopl
just have email and phone but sometime they do have all contact item.
As the report will have to print out all so it will be a bit wasting o
paper then. I designed a report that will dynamically hide blank fiel
and resize report so the print out will be nicely looked without an
big space.
But when I started to put such type of report into a master report
problem occured - the sub-report printed correctly for the first tw
record and the rest with mistakes even the last record have full numbe
of contact item but it printed only 2 fields.
Just problem has put me on the fire for weeks without solution! I woul
be really obliged if you could help me.
Here is the link:
www.sfdp.net/Libs/gen/acc/ql.rar
or you can send me a mail at [email protected] - and I will send yo
the file for testimonial.
Tks in advance for ur helps.
P/S By opening the file - just click print and you will see it
 
Top