Blank lines in report

[tinabee]

I have a WO Table and a related WO Procedures Table. I would like to add a specific # of blank lines/records between each record but that # will vary. So the report will show the WO Procedure Desc then a specified # of blank lines below it and then the next WO Procedures Desc then a specified # of blank lines below it etc. I thought to add a field to the Proc tbl called #ofLines and whatever number was entered would be the # of blank lines to appear below the record on the report.

 

[billmeye]

Take a look at the attached. Open the report in Print Preview for it work. Code is in the ProductID footer On Format.

 

[tinabee]

Hi Bill - that looks great! Since my VBA knowledge is limited though, could you please explain to me how the # of lines is determined?

 

[billmeye]

That is up to you how many lines you would like. You said you were considering adding a column to your table. If you did that then the number of lines could be based on that value.

For X = 1 To Me!NumbOfLines

If you need more help you can attach your DB and I can modify it.