reports

[chris morrison]

I have a table (xxx)that has two checkbox columns, column1
and column2. In my report, if a record has the column1
marked yes (checked), then I would liked fields
a,b,c,d,e,f,g printed. If, on the other hand, column2 is
marked yes (checked), then I want the additional fields
h,i, and j printed. My report is based on a query that I
designed from table xxx. On the query, I have yes marked
in column1 or yes in column2.

Here is the problem. I am printing h, i, and j for all
records. How do I print the extra fields for only records
marked yes in column2. Thanks, chris

 

[chris Morrison]

Yes, I am pre 2000. Thanks for your help

-----Original Message-----
Check out Conditional Formatting. If you are running pre- 2000 versions, come
on back.

--
Duane Hookom
MS Access MVP





.

 

[Duane Hookom]

Then you must use code in the On Format event of the section that contains
all of these fields bound to controls.

Me.txtH.Visible = Me.chkColumn2 = True
Me.txtI.Visible = Me.chkColumn2 = True
Me.txtJ.Visible = Me.chkColumn2 = True