Expanding all fields using can grow when printing

Three Fields.  Question #; Question ID and Question.

The Question can grow = Yes.  How can I have the other 2 fields expand when the Question Field expands.  Right now I am getting gaps in the print alignment,  The height of the question is larger than the other 2 fields.  Thank you.
Startrac98Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
jerryb30Commented:
Can you post a screen shot? Maybe of what you are getting, and what you would like to get.
0
 
Helen FeddemaCommented:
You can get the height of the expanded control in the Detail_Print event, and make the other controls the same height.  Here is some code that makes a green line the same height as an expanded control:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

   Dim sngTop As Single
   Dim sngLeft As Single
   Dim sngHeight As Single
   Dim sngBottom As Single

   sngTop = Me![txtNotes].Top
   sngHeight = Me![txtNotes].Height
   sngLeft = 2300
   sngBottom = sngTop + Me![txtNotes].Height

   Me.DrawStyle = 6
   Me.DrawWidth = 12
   Me.Line (sngLeft, sngTop)-(sngLeft, _
      sngBottom), RGB(0, 255, 0)

End Sub

Open in new window

0
 
Startrac98Author Commented:
I have attached a sample report.  I want all fields to be the same Height as the Question
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jerryb30Commented:
Missed attachment
0
 
Startrac98Author Commented:
I am attaching a file for review
Test.pdf
0
 
Startrac98Author Commented:
Did anyone get a chance to review and solve my problem?
0
 
jerryb30Commented:
Can you post your report in a db?
0
 
Startrac98Author Commented:
A copy of the DB is attached.  Trying to align all field to same size if question which is Can Grow is expanded.
Copy-for-Experts.accdb
0
 
jerryb30Commented:
I have been working on this. Thought it would be simpler. Hope this is not something needing quick resolution.
0
 
Startrac98Author Commented:
OK, thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
<The Question can grow = Yes.  How can I have the other 2 fields expand when the Question Field expands. >
The short answer is that you can't.
This is why I have given up on doing things like this with "Grid-style" reports

Last I researched this, the "height" that a control grows cannot be detected via VBA.
The can Grow property cannot be extended to other textboxes
Despite the appearance, "technically" the CanGrow property does not affect the the size of the detail section.

(You also did not post any info on those other "wColor" textboxes...?
What are they
What do they do?
Why are they there? )

You may want to see if anything here might help.
http://www.lebans.com/PrintLines.htm

If it were me, I would get rid of the vertical grid lines, and just use a horizontal line at the top of the section.
Then use some sort of text instead of the colors, for the colored text boxes.

In this way, only the detail section has any visible delineation.

See my modified version of your db

JeffCoachman
Copy-for-Experts.accdb
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Startrac98Author Commented:
I understand your answer to my question and it makes sense.  I have decided not to persue  and accept the way it is currectly printed.  Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.