Access Report Conditional Format Detail Section. 1

[steinfeld]

I have looked for the soulution for this in many forums. I know how to set a text box and lable .visible to false base on the value in the text box. The problem I have is getting the items below the hidden text box to move up in its place. Instead of just leaving a blank on the report.

 

[abaldwin]

There is not to my knowledge a native Access way of doing this. The only you are going to be able to do what you want is to use the .top proerty of all other controls and modify the current code you have. Add to it the code to loop through the remaining controls and change their .top property to .top -100 (or whatever value you determine would put it where it "belongs".

Then if the control becomes visible move the other controls. Basically a LOT of code if you have a lot of controls.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[steinfeld]

That is perfect. I am using the .top + .height + 2 for the control above and it puts it exactly in place. Thank You!

 

[abaldwin]

Your welcome.
Thanks for the star.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.