Only show "Comments" Label and values when there is data (1 Viewer)

[Funkyaccess]

Hi,

I have a column report i.e in my detail section I have

Col1 | Col2 | Col3
Comments: Comments value

I've report is perfect and I have now added the comments into the report but it not giving me the results I was hoping for. I wanted to only expand the details section and show the comments label and value if there is actual values else simply leave the layout with just col i.e

Col1 | Col2 | Col3

How can I do this using code?

 

[wiklendt]

unfortunately, this is a little tricky, but can be done.

i had to do the same thing myself. here is the thread with a solution that worked for me.

 

[wiklendt]

this thread may be of use to you also. it discusses growing the label with the textbox.

 

[Funkyaccess]

Many thanks that worked perfectly.