<div>
Thanks guys, in the end I just decided to have some text in a box above the subform, I'll condsider an image file solution if my boss still has issues.
</div>


Thanks guys, in the end I just decided to have some text in a box above the subform, I'll condsider an image file solution if my boss still has issues.

<div>
<div class="content wysiwyg-content">
I guess we're all pretty familiar with stacking controls on forms to acheive certain effects by hiding certain controls etc.<br />
<br />
My boss wants me to overlay a textbox or lable over a (continuous forms) subform so that under certain conditions the control overlays the subform indicating that the form is locked. (although I want to keep the subform visible so the data can still be seen)<br />
<br />
Imagine my surprise when after placing a text box 'over' a subform, it stubbornly refuses to 'bring to front' and the subform won't go to back either<br />
<br />
I guess subforms are a special case, but i would be interested if anyone has got any ideas or workarounds ... <br />
<br />
I can implement an alternative solution, but it would be neat if something approaching the ideal could be done<br />
<br />

</div>
</div>


I guess we're all pretty familiar with stacking controls on forms to acheive certain effects by hiding certain controls etc.

My boss wants me to overlay a textbox or lable over a (continuous forms) subform so that under certain conditions the control overlays the subform indicating that the form is locked. (although I want to keep the subform visible so the data can still be seen)

Imagine my surprise when after placing a text box 'over' a subform, it stubbornly refuses to 'bring to front' and the subform won't go to back either

I guess subforms are a special case, but i would be interested if anyone has got any ideas or workarounds ... 

I can implement an alternative solution, but it would be neat if something approaching the ideal could be done



Access 2000 Overlay control on top of subform

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.