adjust height of text box based on height of another text box.

Posted on 2014-03-20
Last Modified: 2014-03-21
I am using MS Access 2003 to genereate a report.  The report has a sub-report on which I have two fields.  The first field contains a number and the second some text.  In those cases where the text runs onto a second line I would like to adjust the height of the first text box to match.  

I tried adding firsttext.height = secondtext.height in the Detail Format section of the subreport but it does not make a differerence.

I then checked the Detail Print section and at that point the height of the secondtext.height  registers the fact that the text box has grown but I cannot adjust the height of the firsttext since the printing has already started.

Does anyone have a solution to this problem.  I have attached a screen shot which shows how the report currently looks.
Question by:Nemetona
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Expert Comment

ID: 39942989
which event are you using to set the height of the first box?

Author Comment

ID: 39943044
I have the height of the firstbox set to the default, it only changes when the secondbox increases in height and that occurs, currently, in the format detail event.

Accepted Solution

COACHMAN99 earned 500 total points
ID: 39943058

Expert Comment

ID: 39943060
Try setting the fontsize the same in both text boxes.

Expert Comment

ID: 39943065
I don't think fonts will help. need to ascertain height of field2 and set field1 on rendering

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access query 16 62
Why Won't My Excel Workbook Refresh The Data 2 47
Intermittent OleDbConnection Error 20 53
Reoccurring Access Query 24 47
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question