reports

  • Thread starter Thread starter chris morrison
  • Start date Start date
C

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
 
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





.
Click to expand...
 
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
 
Back
Top