Printing Selective Fields in "Detail" of Report

[ckrogers]

Hi. I'm a novice at Access programming....
Is there any command that can be used in the detail section of Reports
similar to the "[Field].Visible = True/False" command that can be used in
Forms?
Thanks for your help.
Cindy

 

[Pendragon]

Yes. It follows the same format as what you would type for a form.

Me.MyReportField.Visible = True (or False)

You can do this in the OnOpen property of the report, or in the OnFormat
property of the Detail section if you need to set the visibility from a
condition of the data for each record.

 

[ckrogers]

Perfect ... thanks! The "OnFormat" info really helped me....

Yes. It follows the same format as what you would type for a form.

Me.MyReportField.Visible = True (or False)

You can do this in the OnOpen property of the report, or in the OnFormat
property of the Detail section if you need to set the visibility from a
condition of the data for each record.

Hi. I'm a novice at Access programming....
Is there any command that can be used in the detail section of Reports
similar to the "[Field].Visible = True/False" command that can be used in
Forms?
Thanks for your help.
Cindy

 

[Steve]

Hi Pendragon
I have a similar question on this topic also -
How do I hide from view (and print), a selection of 6 labels and 5 boxes
from a report based on a condition of the data for each record.
Eg. IIf(Mid[myfield],5,1)="G")
I'm afraid I will need the exact syntax for this please.
Also, based on your reply to Cindy - I could not get the following to work
in my report.
Report Section -> On Open -> =[myfield].Visible=No
[myfield] still displays!!
Hope you can help... Thanks
--
Steve

Yes. It follows the same format as what you would type for a form.

Me.MyReportField.Visible = True (or False)

You can do this in the OnOpen property of the report, or in the OnFormat
property of the Detail section if you need to set the visibility from a
condition of the data for each record.

Hi. I'm a novice at Access programming....
Is there any command that can be used in the detail section of Reports
similar to the "[Field].Visible = True/False" command that can be used in
Forms?
Thanks for your help.
Cindy