Can Grow property problem

[Muskiefan]

Access 2007 - I have 2 text box controls, next to one another, in a detail
section of a report. I am programmatically changing the height of each
control based on the value of a field in the recordsource. Both controls
have their Can Grow and Can Shrink properties set to yes. Everything works
fine, the height changes correctly for each control but the text boxes won't
stay on the same line:

textbox1 data
textbox2 data2

Both text boxes are the same height to start with, they are both aligned at
the tops, both are being resized programmatically the same size, they are not
touching each other. I'm completely at my wits end - does anyone have any
ideas or suggestions?

Thanks!

 

[Jeff Boyce]

You may be running into one of the subtle effects of aligning controls
horizontally when one (?or both) are set to CanGrow. As an experiment, see
if 'nudging' one of them a bit lower/higher than the other makes a
difference.

And if these two controls are right next to each other, is there a chance
that they hold some kind of values that are "right next to each other"
(i.e., similar). If so, would you be able to concatenate the values in your
underlying query and just use a single control on the report?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Muskiefan]

Thanks. After a frustration break, I played around with the controls more,
added programming to set the visible/invisible properties, and made one of
the controls slightly taller than the other - it's working now. Thanks alot
for your suggestions.