Report design problem

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

My office decide to switch from excel to access. The db will be used to fill
several vouchers. I have no problem with form but when It come to report I
faced the following:

In excel voucher is designed with header, the body and footer as as access,
the only difference is that in the body of excel form can have many blank
row (so that form is fit to a page). In access, I have difficulty retaining
the blank row (as to keep the form in one page like excel). When I have 1 or
2 detail rows, access just shrink the body of report up and the footer also
shit up. Is there a way to retain 10 blank row after the last detail record
so that the form would fit in one full page?

SF
 
i'm guessing that you placed you "footer" controls in the report's *Report
Footer* section. try moving all those controls into the *Page Footer*
section.

hth
 
Hi SF,

If you only need blank space you can do the following:

1) In a regular module (not a form or report module) place the
following code:

Public Function BlankLines(ByVal intCount) As String

Dim intIndex As Integer
Dim strReturn As String

For intIndex = 1 To intCount
strReturn = strReturn & vbCrLf
Next intIndex
BlankLines = strReturn

End Function

2) In your report's footer (or you can do it in group footers as
appropriate) place text box. Set the text box's Control Source to
"=BlankLines(35-Count(*))" without the quotes, adjusting the 35 to the total
number lines will fit on your page. Also set its Can Grow and Can Shrink
properties to Yes. Set the Can Grow and Can Shrink properties of the footer
to Yes.

Clifford Bass
 
Back
Top