Referencing a textbox in the page header.

[dkaplan]

In an Access Report, can I reference a textbox in the page header from a group header.

The layout is

Page header
[tab]myTextBox
Group Header
[tab]diferentTextBox
I want to stop differentTextBox from printing based on the contents of myTextBox. ie. if myTextBox = "x" then differentTextBox = ""

 

[dhookom]

What have you tried? Where does the value of myTextBox come from?

Duane
Hook'D on Access
MS Access MVP

 

[dkaplan]

The value for MyTextBox comes from the query which is the datasource of the report.

To reference this value, I've tried
[Reports]![reportName].[Section]([acPageHeader]).[MyTextBox].text

also

[Reports]![reportName]![MyTextBox].text

also

me.myTextBox.Text

The intent is:

if me.myTextBox = "x" then DifferentTextBox = "y" else "z

 

[dhookom]

If the value is in the report's record source then bind it to a control in the group header section. It doesn't have to be visible. I don't think you have provided any good reason why you can't use a control source of:

=IIf([myTextBox] = "x","Y","Z")

You would never refer to the Text property of a text box in an Access report. Use the Value property or no property.

Duane
Hook'D on Access
MS Access MVP

 

[dkaplan]

Thanks, dhookom.

It turns out that referencing that value would not have done me much good anyway. I was trying to keep a label from repeating in the in the group header, if it had already appeared in the page header.

I seem to have found the workaround I need by using the group header's onformat event.

Again, Thanks for your input.

Dennis