Hide Values

[Grumm]

Hi, is it possible to hide values on a repory depending on a value entered by user. If they click to generate a repoty they will be prompted with a question 'Include Amount Y/N'. If they type N the report will be produced with the Amount hidden. I can do it on forms but cant see a way on reports.

Cheers

 

[dhookom]

Use code in the On Open event that sets a value

Option Compare Database
Option Explicit
Dim booPrintAmt As Boolean

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.txtAmt.Visible = booPrintAmt
End Sub

Private Sub Report_Open(Cancel As Integer)
booPrintAmt = MsgBox("Print Amt", vbYesNo, "You Pick&quot = vbYes
End Sub


Duane
MS Access MVP