Report Issues

[bisogni]

My dilemma is this:
I have to run an access report that makes certain customer records
easily viewable in a daily report that is to be run. Is it possible to
conditionally shade just the background for certain individual
customers (lets say possibly a dozen different customers which may vary
daily), leaving the remaining report unshaded? The only shading info I
can find is the "every other line" shading which won't help me. I was
trying to look into conditional formatting, but so far have been
unsuccessful.

Any help would be so appreciated.

Thanks

Alex

[fredg]

On 9 Jul 2006 19:17:45 -0700, bi*****@gmail.com wrote:

My dilemma is this:
I have to run an access report that makes certain customer records
easily viewable in a daily report that is to be run. Is it possible to
conditionally shade just the background for certain individual
customers (lets say possibly a dozen different customers which may vary
daily), leaving the remaining report unshaded? The only shading info I
can find is the "every other line" shading which won't help me. I was
trying to look into conditional formatting, but so far have been
unsuccessful.

Any help would be so appreciated.

Thanks

Alex

Not really enough information here.
How do we know which customers you wish to change the color for?
By Name? By some other condition? Do you wish to change just the one
control color, i.e. the CustomerName? Or the color of the entire
detail section for that customer?

For instance, if you wish to change the entire backcolor of the detail
section, you can code the Detail Format event:
If [CustomerName] = "Smith" Or [CustomerName] = "Jones" Then
Me.Section(0).BackColor = vbYellow
Else
Me.Section(0).BackColor = vbWhite
End If

You'll probably want to have the BackStyle of each control in the
section is set to Transparent.

Conditional Formatting will work quite well to change the forecolor of
the controls.
Set the Condition1 to
Expression Is
Write
[CustomerName] = "Jones" Or [CustomerName] = "Smith"
as the condition.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Tom van Stiphout]

On 9 Jul 2006 19:17:45 -0700, bi*****@gmail.com wrote:

The "alternate line shading" code can be adjusted to your needs. It
probably currently tries to figure out if you're on a odd or even row,
and set the background color accordingly.
In PseudoCode:
if RowCount Mod 2 = 0 then
'Even
SetBackgroundColor vbGreen
else
'Odd
SetBackgroundColor vbWhite
end if

Just replace the "RowCount Mod 2 = 0" expression with your
IsCertainCustomer() function or expression.

-Tom.

>My dilemma is this:
I have to run an access report that makes certain customer records
easily viewable in a daily report that is to be run. Is it possible to
conditionally shade just the background for certain individual
customers (lets say possibly a dozen different customers which may vary
daily), leaving the remaining report unshaded? The only shading info I
can find is the "every other line" shading which won't help me. I was
trying to look into conditional formatting, but so far have been
unsuccessful.

Any help would be so appreciated.

Thanks

Alex

[Ascerbus]

bi*****@gmail.com wrote:

My dilemma is this:
I have to run an access report that makes certain customer records
easily viewable in a daily report that is to be run. Is it possible to
conditionally shade just the background for certain individual
customers (lets say possibly a dozen different customers which may vary
daily), leaving the remaining report unshaded? The only shading info I
can find is the "every other line" shading which won't help me. I was
trying to look into conditional formatting, but so far have been
unsuccessful.

Any help would be so appreciated.

Thanks

Alex

I am new to this group and relatively new to Access programming, but
maybe I can help a little bit here. Fred's reply sounds like what you
are looking for as far as formatting goes, but typing in each
individual's name in the code seems a bit tedious. If I understand
your situation correctly I would take Fred's suggestion one step
further and create a small form or pop-up box that would include a list
of all customers who you could possibly want shaded on the report. Add
a field that is called "Shade" or something to that effect and make it
a yes/no field. You can then run the macro with a conditional
statement where you can apply the back/fore color if the Shade field =
Yes. You can even take that a step further and run an append query
when you are finished with the daily report to clear all "Yes" records
in the "Shade" field.

Again, I am new to this group so hello to everyone. I don't know if my
two cents help here. If there is a better way of going about selecting
customers for this conditional formatting I am all ears as well as I am
sure Alex is.

---Tim Dunne