not printing certain columns

  • Thread starter Thread starter Guest
  • Start date Start date
If you are using Access 2k or later, you can use conditional formatting. You
can specify an Expression like
[FieldA]=0 And [FieldB]=0
You can also use code in the on format event of the section containing the
controls.

Me.txtFieldA.Visible = Not ([FieldA]=0 And [FieldB]=0)
Me.txtFieldB.Visible = Not ([FieldA]=0 And [FieldB]=0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epson XP-3150 not printing 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Comparing two columns 1
Printing Landscape with columns and page numbers 1
How do I get report to print this way? 1
Variable number of columns 4
Print macro that hides rows before printing 1
Excel Fit to page print options in Excel 1

Back
Top