Report Output

J

Jeff@Tufts

Hi,

I have a created a check box (on the table, query & form). The box will
indicate that a number enter in another field is a place holder. When I run
the report for that field I want the number (font) to be red IF the box has
been checked.

How do I link the checkbox to the field in the report???

Thanks,
Jeff
 
A

Arvin Meyer [MVP]

Try using an expression in a Conditional Format. In the report's Design
View, select the text box which hold the number field, go to the Format
menu, then Conditional Formatting and set your condition.
 
J

Jeff@Tufts

I very new with Access and have no idea how to write the expression in a
conditional format.
 
J

Jeff@Tufts

I'm using 2003. I'm in the report and cannot find "Conditional Formating".

Also, will this make the background of the text box red if the check box is
checked?

Arvin Meyer said:
Say the check box is named chkYN1

In Design View, select the text box you want to color

Go To Format >>> Conditional Formatting

Under Condition 1, select Expression

use the following expression:

[chkYN1]=-1

Change the background fill to Red.

Save
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Jeff@Tufts said:
I very new with Access and have no idea how to write the expression in a
conditional format.
Click to expand...
Click to expand...
 
A

Arvin Meyer [MVP]

1. Open the report in Design View

2. Open the property sheet

3. select the text box you want to back color

4. Go to the Format menu

5. click on Conditional Formatting

6. follow the directions below
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Jeff@Tufts said:
I'm using 2003. I'm in the report and cannot find "Conditional
Formating".

Also, will this make the background of the text box red if the check box
is
checked?

Arvin Meyer said:
Say the check box is named chkYN1

In Design View, select the text box you want to color

Go To Format >>> Conditional Formatting

Under Condition 1, select Expression

use the following expression:

[chkYN1]=-1

Change the background fill to Red.

Save
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Jeff@Tufts said:
I very new with Access and have no idea how to write the expression in a
conditional format.

:

Try using an expression in a Conditional Format. In the report's
Design
View, select the text box which hold the number field, go to the
Format
menu, then Conditional Formatting and set your condition.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi,

I have a created a check box (on the table, query & form). The box
will
indicate that a number enter in another field is a place holder.
When
I
run
the report for that field I want the number (font) to be red IF the
box
has
been checked.

How do I link the checkbox to the field in the report???

Thanks,
Jeff
Click to expand...
Click to expand...
Click to expand...
 
Top