Reports: Click to reveal or similar

[tb1150]

Hi all,


I have a report where I would like a small box to denote the status of a field(easy with conditional formatting), and if the user clicks/hovers over the box it will display the whole field. This is just because the field in question often ends up being a couple paragraphs and it's not ideal to display that sort of information again and again in a report.
Any suggestions? Much appreciated.

[tb1150]

Right now my only solution is to write a VBA that has a dao recordset with the field in and when the box is clicked it executes a messagebox. However this is not ideal.

[IrogSinta]

If the field is in the recordsource of the report, you can just add it anywhere in the report and set its Visible property to False. Then in your OnClick event. You can refer to that control in your message box.
MsgBox Me.NameOfInvisibleControl

Ron

[tb1150]

This is a much simpler way to do it I think. Simplicity is key. Thanks Ron!