Suppress Report Footer

I have three footers in my report:

COM_VAD
PROCESS
LABEL_TYPE

PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?

Thank you in advance!

Karen

On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:

I have three footers in my report:

COM_VAD
PROCESS
LABEL_TYPE

PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?

Thank you in advance!

Karen

Code the Process Footer Format event:
Cancel = Me![ControlName] = "Canned"

Where the (X) is the Group header's section number, i.e. the Report
Header is section(1), the PageFooter is section(4), etc.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned"
assuming the [ControlName] is the field called Process. It comes back and
says it can't find the field. Not sure what you mean by "where the (x) is
the...." The Process Group Footer shows as GroupFooter0. Event procedures
are new to me.

"fredg" wrote:

On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:

I have three footers in my report:

COM_VAD
PROCESS
LABEL_TYPE

PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?

Thank you in advance!

Karen

Code the Process Footer Format event:
Cancel = Me![ControlName] = "Canned"

Where the (X) is the Group header's section number, i.e. the Report
Header is section(1), the PageFooter is section(4), etc.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Tue, 30 Oct 2007 12:39:00 -0700, frpkaren wrote:

You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned"
assuming the [ControlName] is the field called Process. It comes back and
says it can't find the field. Not sure what you mean by "where the (x) is
the...." The Process Group Footer shows as GroupFooter0. Event procedures
are new to me.

"fredg" wrote:

On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:

I have three footers in my report:

COM_VAD
PROCESS
LABEL_TYPE

PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?

Thank you in advance!

Karen

Code the Process Footer Format event:
Cancel = Me![ControlName] = "Canned"

Where the (X) is the Group header's section number, i.e. the Report
Header is section(1), the PageFooter is section(4), etc.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


1) [Process] is the name of your table field that stores "Canned" or
"SomeOtherValue"
The name of the control in the report may or may not be "Process".
You need to refer the actual name of the control in the Process Group
Header that displays the value "Canned". Look at it's property sheet
on the Other tab.

2) Is [Process] a text datatype field, or is it a LookUp field.
Look in table design view. If the datatype of the Process field is
Text, fine. If, however, it is Number, look at the LookUp tab in the
lower panel. It will say Combo Box.
You are using that infamous lookup field, which stores a Number value
but displays text.
You can most likely substitute the "Canned" number value:
Cancel = Me.[Process] = 3
Where 3 is whatever the actual value is. You'll need to look it up in
whatever table you are storing the Process values.

Once again, make sure that [Process] is the actual name of the
control.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

THANK YOU! I ended up adding a text box to the footer for the field Process;
inserted the control name of the new text box in the Event Procedure and
everything works fine. Set the property on the new text box to not visible
because I really don't need it to show. You're a life saver!

"fredg" wrote:

On Tue, 30 Oct 2007 12:39:00 -0700, frpkaren wrote:

You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned"
assuming the [ControlName] is the field called Process. It comes back and
says it can't find the field. Not sure what you mean by "where the (x) is
the...." The Process Group Footer shows as GroupFooter0. Event procedures
are new to me.

"fredg" wrote:

On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:

I have three footers in my report:

COM_VAD
PROCESS
LABEL_TYPE

PROCESS is either canned or frozen. COM_VAD is either commodity or
value-added. Frozen can be either commodity or value-added; canned will only
be commodity. How can I suppress the PROCESS footer if the process is canned?

Thank you in advance!

Karen

Code the Process Footer Format event:
Cancel = Me![ControlName] = "Canned"

Where the (X) is the Group header's section number, i.e. the Report
Header is section(1), the PageFooter is section(4), etc.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


1) [Process] is the name of your table field that stores "Canned" or
"SomeOtherValue"
The name of the control in the report may or may not be "Process".
You need to refer the actual name of the control in the Process Group
Header that displays the value "Canned". Look at it's property sheet
on the Other tab.

2) Is [Process] a text datatype field, or is it a LookUp field.
Look in table design view. If the datatype of the Process field is
Text, fine. If, however, it is Number, look at the LookUp tab in the
lower panel. It will say Combo Box.
You are using that infamous lookup field, which stores a Number value
but displays text.
You can most likely substitute the "Canned" number value:
Cancel = Me.[Process] = 3
Where 3 is whatever the actual value is. You'll need to look it up in
whatever table you are storing the Process values.

Once again, make sure that [Process] is the actual name of the
control.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail