If (1 Viewer)

[mike60smart]

Hi Everyone

I have an Invoice type report with one of the Controls named "TaxExempt"

If this Control has a value of "Yes" I want the following to happen

If Me.TaxExempt = "Yes" Then
Me.T.Visible = True
Me.Notice.Visible = True
Else
Me.T.Visible = False
Me.Notice.Visible = False
End If

Where would it be best to place this code?

Edit **

I placed the code in the On Open event of the form and I now get the following error

When I hit Debug it highlights this line

If Me.TaxExempt = "Yes" Then

 

[isladogs]

As its a report, place it in the On Format event of the section where the control is located e.g. Detail_Format
Note that will only have an effect when the report is in print preview or actually printed

 

[NauticalGent]

Good morning. I would think the OnLoad event would be the best place to put this code.

 

[NauticalGent]

Apologies, I did not see that Col has responded. That being said, he is much more familiar with report events than I am. I would try his suggestion first!

 

[mike60smart]

Hi Colin

Now that is strange

I placed the code in the On Format of the Form and now when the Control Tax Exempt value = Yes all of my Total Calculations display as follows:-

And when the Tax Exempt value = No all the calulations work as normal ?

 

[isladogs]

You originally said it was a report and my answer was based on that.
Now you mention a form. Which is it?

 

[June7]

If this is a report:

Place code in Format event of section where data is located. Is TaxExempt a text or yes/no field?

Format event only triggers for direct to printer or PrintPreview, not ReportView.

 

[isladogs]

June. See post #2.

 

[mike60smart]

My apologies It is a Report

 

[isladogs]

OK - what report view are you using?
Also as asked by June, what datatype is field TaxExempt?

 

[mike60smart]

Hi Colin

That works just great when I managed to locate the Format option

Many thanks yet again