Conditional Format

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

Is there anyway to use a "conditional format" in a
report? My example is if a salesman has sold more than
$100,000 for the year, then his name is highlighted. The
report of the salesmen's names and sales figures is drawn
from a querry based on a table.
It would be my preference to fill the background yellow,
of the salesman name field, but I would be content to
change the type to red. Thanks in advance for the help.
 
Seems to me that you should explain if there is a field or text box in the
same section as the salesman name that contains his/her sales for the year.
 
Yes, the detail section contains two fields, Salesman
Name and Sales. Salesman Name is Text and Sales is a
number. The difficulty I am having is referencing the
Sales figure to conditionally format the Salesman Name.
I can coditionally format the Sales field with no
problem, but can't figure out the expression to use to
reference the Sales number when I am conditionally
formating the Salesman Name text field.
Gene
 
Is the Sales field contain the total for the year? If so, you can set the
condition to Expression is
[SalesForYearField]>=100000
 
Duane, Thank you for your time. I have tried using the
field name in brackets, and the correct record has the
background filled in the Salesman Name field, so it is
recognizing the conditional formatting, BUT, the value
printed on the report is "#Name?", not the name of the
salesman. Have you ever heard of this?
Thanks again.
Gene
-----Original Message-----
Is the Sales field contain the total for the year? If so, you can set the
condition to Expression is
[SalesForYearField]>=100000


--
Duane Hookom
MS Access MVP


Yes, the detail section contains two fields, Salesman
Name and Sales. Salesman Name is Text and Sales is a
number. The difficulty I am having is referencing the
Sales figure to conditionally format the Salesman Name.
I can coditionally format the Sales field with no
problem, but can't figure out the expression to use to
reference the Sales number when I am conditionally
formating the Salesman Name text field.
Gene field
or text box in the his/her
sales for the year.
Click to expand...


.
Click to expand...
 
What is the name of the text box and the control source of the text box?

--
Duane Hookom
MS Access MVP


Gene said:
Duane, Thank you for your time. I have tried using the
field name in brackets, and the correct record has the
background filled in the Salesman Name field, so it is
recognizing the conditional formatting, BUT, the value
printed on the report is "#Name?", not the name of the
salesman. Have you ever heard of this?
Thanks again.
Gene
-----Original Message-----
Is the Sales field contain the total for the year? If so, you can set the
condition to Expression is
[SalesForYearField]>=100000


--
Duane Hookom
MS Access MVP


Yes, the detail section contains two fields, Salesman
Name and Sales. Salesman Name is Text and Sales is a
number. The difficulty I am having is referencing the
Sales figure to conditionally format the Salesman Name.
I can coditionally format the Sales field with no
problem, but can't figure out the expression to use to
reference the Sales number when I am conditionally
formating the Salesman Name text field.
Gene
-----Original Message-----
Seems to me that you should explain if there is a field
or text box in the
same section as the salesman name that contains his/her
sales for the year.

--
Duane Hookom
MS Access MVP


message
Is there anyway to use a "conditional format" in a
report? My example is if a salesman has sold more than
$100,000 for the year, then his name is highlighted.
The
report of the salesmen's names and sales figures is
drawn
from a querry based on a table.
It would be my preference to fill the background
yellow,
of the salesman name field, but I would be content to
change the type to red. Thanks in advance for the
help.


.
Click to expand...


.
Click to expand...
Click to expand...
 
Duane,
The whole report is based on a table:
tblMonthlyPerformanceSummary
The Text box with the Salesman Name is named CO and the
text box for the Sales field is called ManagerSales. In
the control source, the CO field is a text field with 255
characters, and the ManagerSales field is a long integer.
Gene
-----Original Message-----
What is the name of the text box and the control source of the text box?

--
Duane Hookom
MS Access MVP


Duane, Thank you for your time. I have tried using the
field name in brackets, and the correct record has the
background filled in the Salesman Name field, so it is
recognizing the conditional formatting, BUT, the value
printed on the report is "#Name?", not the name of the
salesman. Have you ever heard of this?
Thanks again.
Gene
-----Original Message-----
Is the Sales field contain the total for the year? If so, you can set the
condition to Expression is
[SalesForYearField]>=100000


--
Duane Hookom
MS Access MVP


Yes, the detail section contains two fields, Salesman
Name and Sales. Salesman Name is Text and Sales is a
number. The difficulty I am having is referencing the
Sales figure to conditionally format the Salesman Name.
I can coditionally format the Sales field with no
problem, but can't figure out the expression to use to
reference the Sales number when I am conditionally
formating the Salesman Name text field.
Gene
-----Original Message-----
Seems to me that you should explain if there is a field
or text box in the
same section as the salesman name that contains his/her
sales for the year.

--
Duane Hookom
MS Access MVP


message
Is there anyway to use a "conditional format" in a
report? My example is if a salesman has sold
Click to expand...
more
than
$100,000 for the year, then his name is highlighted.
The
report of the salesmen's names and sales figures is
drawn
from a querry based on a table.
It would be my preference to fill the background
yellow,
of the salesman name field, but I would be
Click to expand...
content
to
change the type to red. Thanks in advance for the
help.


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
What I was getting at is the control name can't be the same name as a field
name unless the control name is exactly the same as the control source
property. IE: a text box with a control source of
=FirstName & " " & LastName
can't be named
FirstName

--
Duane Hookom
MS Access MVP


Gene said:
Duane,
The whole report is based on a table:
tblMonthlyPerformanceSummary
The Text box with the Salesman Name is named CO and the
text box for the Sales field is called ManagerSales. In
the control source, the CO field is a text field with 255
characters, and the ManagerSales field is a long integer.
Gene
-----Original Message-----
What is the name of the text box and the control source of the text box?

--
Duane Hookom
MS Access MVP


Duane, Thank you for your time. I have tried using the
field name in brackets, and the correct record has the
background filled in the Salesman Name field, so it is
recognizing the conditional formatting, BUT, the value
printed on the report is "#Name?", not the name of the
salesman. Have you ever heard of this?
Thanks again.
Gene
-----Original Message-----
Is the Sales field contain the total for the year? If
so, you can set the
condition to Expression is
[SalesForYearField]>=100000


--
Duane Hookom
MS Access MVP


Yes, the detail section contains two fields, Salesman
Name and Sales. Salesman Name is Text and Sales is a
number. The difficulty I am having is referencing the
Sales figure to conditionally format the Salesman Name.
I can coditionally format the Sales field with no
problem, but can't figure out the expression to use to
reference the Sales number when I am conditionally
formating the Salesman Name text field.
Gene
-----Original Message-----
Seems to me that you should explain if there is a
field
or text box in the
same section as the salesman name that contains
his/her
sales for the year.

--
Duane Hookom
MS Access MVP


message
Is there anyway to use a "conditional format" in a
report? My example is if a salesman has sold more
than
$100,000 for the year, then his name is highlighted.
The
report of the salesmen's names and sales figures is
drawn
from a querry based on a table.
It would be my preference to fill the background
yellow,
of the salesman name field, but I would be content
to
change the type to red. Thanks in advance for the
help.


.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top