Anyone know a way around this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"For report sections, you can't use a macro or Visual Basic to set the Height
property when you print or preview a report."

That's straight from the help files for MS Access. I read this and
understand. Nevertheless, I have to find some way of adding extra blank
space after certain records in the detail section of my report:

If IsNull(Location) = False Then
'add extra blank space between the end of this record and the beginning
of the
'next
Else
'keep spacing as is
End If

Any suggestions?

Many thanks,

Joe
 
In the place where you want the extra blank space to go, put a textbox
control on the report. Set its Control Source to this:

=IIf(IsNull([Location]) = False, " " & Chr(13) & Chr(10), "")


Set the textbox control's Can Grow and Can Shrink properties both to Yes.
Size the textbox's height to 0.05".

That should do what you want.
 
Thank you for your response, but that is, in fact, what I first tried before
posting. I tried using VB to set the height of the detail section within the
format event. This produced the following run-time error:

"This property is read-only and can't be set." (Error 2135)
 
Back
Top