Add blank records to Detail section

[Rattlesnake]

Hi,
I have report that displays records in a tabular format. (the fields have a border to them so the reports looks like a table)
The number of records may vary according to certain conditions.
What I want is that the report should always print a minimum number of records say 25 , irrespective of the number of actual records in the report. For eg,
If there are 15 records in the report , it should print 10 blank lines (25 minus 10). When the blank lines are printed , the borders will be printed hence the report will look like a table with 25 lines.

Is this possible??


Thanks

 

[Rickster57]

Lines in report

Place the following code in the On Page property of your report. It will print 25 lines down the report no matter how many records you have. You will have to make a few adjustments. If you don't want the lines to show just make the color of the line to white. Let me know if this gets you in the right direction.

 

[Rattlesnake]

I think you forgot the CODE.

 

[Alancamsur]

hi rattlesnake,

can you send me your code about the lines in report that extends to the page footer no matter how many records to be printed. thanks.

 

[Rickster57]

Invisible code

Sorry about that. Must be getting old(er).

Dim intRows As Integer
Dim intLoop As Integer
Dim intTopMargin As Integer
Dim intDetailHeight As Integer
intRows = 24
intDetailHeight = Me.Section(0).Height
intTopMargin = 360
Me.FontSize = 16
For intLoop = 0 To intRows
Me.CurrentX = 20
Me.CurrentY = intLoop * intDetailHeight + intTopMargin
Me.Print intLoop + 1
Me.Line (0, intLoop * intDetailHeight + intTopMargin)- _
Step(Me.Width, intDetailHeight), , B
Next

 

[phil.spencer@cl]

Hi,
My first visit to forum. Adding lines code works brilliantly. Any ideas how I can make 5 boxes of different width to form a full table.

 

[djshidler]

I need some help entering multiple fields into a report/letter from a table. Since this is a letter it is not always the same amount of fields and data. How would I block out the fields in the detail section of the report? Does this call for a macro? Thanks for any help!