If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
One record one page shrink grow within single page
Win2000 SP4 + Access 2000 (.adp) + SQL Server 2000 SP3a
Hopefully this can be done, and hopefully someone wouldn't mind pointing me in the right direction Can I have one record per page on a report and no matter how large (in volume) the data is, it won't go onto another page, but on a single page the objects can shrink / grow if they need to but only to a maximum. One record, one page. eg 1* A4 Lanscape report 2* text box's divide the page in half exactly. Can shrink is set to YES, can grow set to YES as the two text box's are varchar(2500) So if the box's need to grow or shrink they can do, but to not go beyond the boundry of one record one page? Many thanks. Steve'o |
#2
|
|||
|
|||
"Steve'o" wrote:
Win2000 SP4 + Access 2000 (.adp) + SQL Server 2000 SP3a Hopefully this can be done, and hopefully someone wouldn't mind pointing me in the right direction Can I have one record per page on a report and no matter how large (in volume) the data is, it won't go onto another page, but on a single page the objects can shrink / grow if they need to but only to a maximum. One record, one page. eg 1* A4 Lanscape report 2* text box's divide the page in half exactly. Can shrink is set to YES, can grow set to YES as the two text box's are varchar(2500) So if the box's need to grow or shrink they can do, but to not go beyond the boundry of one record one page? Many thanks. Steve'o I should add that although these are run of on reports, there is no totalling/grouping, so if its easier / any different, Im open to the possibility of doing this in a form rather than a report?? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Printing mailmerge document for single record from a form | Clare | Setting Up & Running Reports | 3 | October 5th, 2004 01:37 PM |
print one record per page (10 labels per sheet) w/ multiple record | Lou K | General Discussion | 1 | September 7th, 2004 11:22 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |