Can Users Control Section Height

[Guest]

Hi.

I have a report Section containing fields that are set to cangrow and
canshrink. Now the users tell me that they need the section height to
increase to a fixed height, around 4inches, for certain records. This is to
allow someone else to write relevant details in the space created. And sorry
but, before you suggest it, they dont want to enter this in a database text
field - they have to write it on the report printout.

Rather than increasing the height for all records, with resultant waste of
paper, I was thinking that I could put a Check Box on the relevant form such
that, when checked, it causes the section height to change to 4inches for
that record and otherwise defaults to the normal height, as determined by the
deepest text box.

Can anyone suggest the Event and code that I could put, presumably in the
GroupHeader, if the Check Box is called PrintDeep? Or is there a better way
of doing this?

Thanks in avance, JohnB

 

[Duane Hookom]

You might want to set a control source to an expression like:
=IIf(Forms!frmYourForm!chkBox=True,String(20,Chr(13) & Chr(10)),"")
This should make the text box 20 "lines" tall.

 

[Guest]

Thanks for this Duane.

I threw something together quickly but Im getting #Name apearing in the
field. Just to make sure I understand - I create a check box on my form and
name it chkBox, then I add an unbound field to my report section with control
source as your code, then I adjust your code accordingly with my form name. I
presume the chkbox has to be bound to a table. Is this correct? I may just
have made a silly mistake. Otherwise I will repost with my exact names. Sorry
this will have to be tomorrow - just finishing now. Thanks again. JohnB

 

[Duane Hookom]

If your form is open and if you want each record in the report to react the
same in terms of detail height then you don't need the check box to be
bound. If the individual record determines the height then you will need to
store a value in the table.

 

[JohnB]

Hi again Duane. Thanks for the further info.

Im sorry but I didnt get to look at this again today. However, Im sure I can
get it going, so let me just say thank you for now and Ill repost if I still
have any difficulties.

Cheers, JohnB