moving text boxes

[Gouda42]

i have a large report with lots of text boxes, based on the criteria some text boxes are set to visible and disappear. I have other text boxes below and would like to get them to slide up on the report.

I know about the textbox.move method but I haven't been able to get it to work any advice would be appreciated.

text box - FFC_Account

Thanks

 

[theDBguy]

Hi. Do you just need to move them up, not sideways?

 

[Gouda42]

Yea just move them up.

 

[Gouda42]

I also don’t know what sort of sub it should be under as well. I am going to eventually export them to pdf

 

[Gouda42]

what i was sort of thinking was

If IsNull(Me.Eur_Intructions) Then

Me.FFC_Account.move(500, 500, 0, 0)


it obviously doesnt work but thats what i thinking

 

[theDBguy]

Yea just move them up.

An easy way to achieve something similar is to stack the textboxes next to each other (up and down) and then set their height to zero (or very small) and use the Can Grow property (set to Yes). If there are labels involved, you could try replacing them with textboxes containing IIf() expressions to display the label or none, depending on the related textbox data. Hope it helps...

 

[Gouda42]

so i have already turned all my labels into text boxes because i have seen a thread before addressing visible labels,

i have changed the height to zero and when i go into report view i do see it shift up but the problem is that i have a customized report where i have inserted lines around a grouping of text boxes. i have a VBA If for if there is no data in the group of text boxes then the lines should disappear. I have the lines on the ON_Click event.
i am not comfortable with the event tab of the report page so if there is a better event that would automatically remove my lines right when i went to report view instead of me changing my report to report view then clicking on the screen
i realize i have sort of drifted off the main topic but any advice would be appreciated.

 

[theDBguy]

Hi. If you'll notice, I am still trying to avoid giving you any VBA suggestions because if the issue can be handled with a simpler approach, I tend to go in that direction. So, as for the lines on your report, here's another possible approach for you. Report Gridlines

 

[Gouda42]

So Decided to get rid of lines becasue it became too much of a headache, but going back to where you said set the text box to grow, and give it no height. When doing that it does shift up but only till it hits where the txt box above it would be.

on the pages of the report where the text box disappears the one txt box that i need to move up barely moves.

I realize that i am making this more difficult especially because this is just a cosmetic issue but i appreciate the help.

 

[Deleted member 147267]

I think your only hope would be vba in the FormatDetail event but even if you're successful, now you have to shrink the detail section to eliminate white space? Honestly, I'd look for a way to redesign the layout but can only guess at what you might do without seeing what you start with. One option might be concatenated controls that get data from hidden bound controls, thus whatever is null doesn't matter.