Filling up a page with blank lines (Access03)

Topic

New Reply

I have created a report that has peoples names separated by horizontal lines and there are also vertical lines. How can I with VBA draw these lines to fill up any incomplete page? I want to do this so if new names need to be added they can be written in. Thank you.

Fay

Reply | Quote

Replies

See MSKB article ACC2000: How to Print a Constant Number of Lines Per Group (it applies to Access 2003 too). You can download a sample database with a working example. It shouldn’t be hard to modify the code for your use.

Reply | Quote

Thanks Hans. I am currently trying to get it to work. Appreciate the pointer. Fay

Reply | Quote