Anyone know a way around this?

J

Joe

"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
 
K

Ken Snell [MVP]

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.
 
J

Joe

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)
 
Top