Closing up empty records

DesBlair · #1 06-23-2005, 10:32 AM

I have a feeling this has been answered here before but I can't make it work. I want to print data to a report based on boxes ticked in a form. Please see example attached. This works fine, but for the unticked boxes I want to close up the empty space(s) - much as happens with the address label wizard. I have tried setting the can grow and can shrink options but to no avail. Can anyone help please?

ThreeCrow · #2 06-23-2005, 11:57 AM

Those controls that do have data will hold the space open
What kind of report is it

DesBlair · #3 06-23-2005, 01:15 PM

Hi ThreeCrows. Please see Example report and Form attached to my original Request. Thanks

DesBlair

WayneRyan · #4 06-24-2005, 12:59 PM

DesBlair,

I don't know if this is even the right approach. Look at the DetailFormat
event of the report.

Wayne

DesBlair · #5 07-02-2005, 05:23 AM

Thanks a lot Wayne - It hadn't occured to me to put evrything into an unbounded text box. I am new to VBA but managed to follow your procedure except that I do not know the purpose of the "& VbCrLf" statement?

Thanks again

Des

#6 07-02-2005, 05:46 AM

CrLf; carriage return line feed, in other words a new line

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Procedure too large, what can I do??	wh00t	Modules & VBA	15	01-17-2008 06:05 PM
Autofilling records	diversoln	Forms	1	11-03-2003 12:14 PM
excluding records	Tim L	Queries	3	10-22-2003 11:44 AM
locked and unlocked records	Webster01	Forms	1	03-26-2002 08:25 AM
How to sort records by user's input sequence in a form?	pat2828	Forms	1	02-13-2002 06:16 AM