Conditional Formatting

Lisa wrote:
I need those fields in the detail section as well as in the header. I would
like For Example
Laurel 89%
Jan Feb Mar Q1-07
5% 15% 7% 8%
Laurel 2% 10% 5% 89%

So putting Field0 and Field4 i the header takes them out of the detail and
they need to be there to.


Seems redundant to me, but if you want something to appear
in both the group header and detail, then add those fields
to both sections.

I'm afarid that I am losing track of what you have in the
various report sections and how it differs from what you
want.

--
Marsh
MVP [MS Access]

The reason they need to be in both is because We want the stores to be able
to see how they have done against all of the other stores but we don't want
them to see the store names only there numbers, that is why I only want the
store name at the top and in the body to be seen with all of the other stores
names not seen.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:
I need those fields in the detail section as well as in the header. I would
like For Example
Laurel 89%
Jan Feb Mar Q1-07
5% 15% 7% 8%
Laurel 2% 10% 5% 89%

So putting Field0 and Field4 i the header takes them out of the detail and
they need to be there to.


Seems redundant to me, but if you want something to appear
in both the group header and detail, then add those fields
to both sections.

I'm afarid that I am losing track of what you have in the
various report sections and how it differs from what you
want.

--
Marsh
MVP [MS Access]

Lisa wrote:

The reason they need to be in both is because We want the stores to be able
to see how they have done against all of the other stores but we don't want
them to see the store names only there numbers, that is why I only want the
store name at the top and in the body to be seen with all of the other stores
names not seen.


Sorry, but I don't understand what that means in terms of
your reports.

Do you now have it working the way you want?

--
Marsh
MVP [MS Access]

No I do not. May be conditional formatting is not what I need to do.
Everything works on my report the way I want except the store names. Either
all of the appear or I can hide all of them, I have been able to find a way
to have the store name at the top of the report be the only store name to
appear in the body of the report.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

The reason they need to be in both is because We want the stores to be able
to see how they have done against all of the other stores but we don't want
them to see the store names only there numbers, that is why I only want the
store name at the top and in the body to be seen with all of the other stores
names not seen.


Sorry, but I don't understand what that means in terms of
your reports.

Do you now have it working the way you want?

--
Marsh
MVP [MS Access]

Lisa wrote:

No I do not. May be conditional formatting is not what I need to do.
Everything works on my report the way I want except the store names. Either
all of the appear or I can hide all of them, I have been able to find a way
to have the store name at the top of the report be the only store name to
appear in the body of the report.


I feel fairly confident that we can get the effect that you
want, but I still don't understand what that is.

I reviewing all the messages, I kind of have a feeling that
you want the subreport to display all stores for every store
in the main report. I.e. repeating the same information
over and over with only one subreport record displaying the
store name. If that is a valid interpretation, then try
adding a line of code to the subreport fetail section's
Format event:
Me.storenametextbox.Visible = (Me.storenametextbox =
Parent.storenametextbox)

--
Marsh
MVP [MS Access]

Thank you for working with me that code is working perfectly. Thank you again.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

No I do not. May be conditional formatting is not what I need to do.
Everything works on my report the way I want except the store names. Either
all of the appear or I can hide all of them, I have been able to find a way
to have the store name at the top of the report be the only store name to
appear in the body of the report.


I feel fairly confident that we can get the effect that you
want, but I still don't understand what that is.

I reviewing all the messages, I kind of have a feeling that
you want the subreport to display all stores for every store
in the main report. I.e. repeating the same information
over and over with only one subreport record displaying the
store name. If that is a valid interpretation, then try
adding a line of code to the subreport fetail section's
Format event:
Me.storenametextbox.Visible = (Me.storenametextbox =
Parent.storenametextbox)

--
Marsh
MVP [MS Access]

Marshall,
I am getting a error of 2452 Expression you enters is invalad refernece to
parent property. The code works, if I debug and close and then open the
report again without using the from it works great but the report will open
by the form because of the error, can you halp in fixing the error.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

No I do not. May be conditional formatting is not what I need to do.
Everything works on my report the way I want except the store names. Either
all of the appear or I can hide all of them, I have been able to find a way
to have the store name at the top of the report be the only store name to
appear in the body of the report.


I feel fairly confident that we can get the effect that you
want, but I still don't understand what that is.

I reviewing all the messages, I kind of have a feeling that
you want the subreport to display all stores for every store
in the main report. I.e. repeating the same information
over and over with only one subreport record displaying the
store name. If that is a valid interpretation, then try
adding a line of code to the subreport fetail section's
Format event:
Me.storenametextbox.Visible = (Me.storenametextbox =
Parent.storenametextbox)

--
Marsh
MVP [MS Access]

Never mind Marshall I fixed the problem
--
Lisa S.


"Lisa" wrote:

Marshall,
I am getting a error of 2452 Expression you enters is invalad refernece to
parent property. The code works, if I debug and close and then open the
report again without using the from it works great but the report will open
by the form because of the error, can you halp in fixing the error.
--
Lisa S.


"Marshall Barton" wrote:

Lisa wrote:

No I do not. May be conditional formatting is not what I need to do.
Everything works on my report the way I want except the store names. Either
all of the appear or I can hide all of them, I have been able to find a way
to have the store name at the top of the report be the only store name to
appear in the body of the report.


I feel fairly confident that we can get the effect that you
want, but I still don't understand what that is.

I reviewing all the messages, I kind of have a feeling that
you want the subreport to display all stores for every store
in the main report. I.e. repeating the same information
over and over with only one subreport record displaying the
store name. If that is a valid interpretation, then try
adding a line of code to the subreport fetail section's
Format event:
Me.storenametextbox.Visible = (Me.storenametextbox =
Parent.storenametextbox)

--
Marsh
MVP [MS Access]