How can i hide a label and textbox in a report

[Raghavender143]

Hi all

How can i hide a label and associated textbox in a report in access
my report looks like this

Name Jan Feb Mar Apr May ......


i only display for any two months requested by the user, so the remaining i dont want to display the empty columns

pleaseee help me....

[Rabbit]

Just have the query create a Month1 and Month2 field populated with the two chosen months. Then your report can just use those two fields no matter what month they are.

[Raghavender143]

Hi

My problem is i am using a crosstab query sometimes the user may want 3 months report, so can u help me in hiding those labels and textboxes of the report.

[Rabbit]

Hi

My problem is i am using a crosstab query sometimes the user may want 3 months report, so can u help me in hiding those labels and textboxes of the report.

Okay... that's not what you said in the first post.

How does the user indicate what months they want in the report?

[Raghavender143]

Hi

I am actually deriving it from other query, that query asks the user to enter the start date then it displays for three months....

[Rabbit]

Hi

I am actually deriving it from other query, that query asks the user to enter the start date then it displays for three months....

You can use the same method I mentioned earlier, except add an extra month. If you need to hide a column then you can do it through the Open event of the report.