Changing colors for Text Box - can't figure it out

  • Thread starter Thread starter J Nachbar
  • Start date Start date
J

J Nachbar

I'm trying to have a report display text boxes in different colors based on simple selection criteria. Ideally, I'd have a separate table containing the color choices / criteria, but can accept alternate methods.

I've seen several posts about changing color attributes, and have checked the Access Help screen. The use of "Contitional Formatting" sounds like it may do the trick for me, but I must be overlooking something, as I can't find "Conditional Formatting" anywhere on my Design View control menus.

I'd apprecitate any help. Either:
1- Where do I find Conditional Formatting? How to use?
2- Alternate methods to change colors based on selection criteria.

I'm using Access2000. I've done some limited work with Access code writing. Not my forte.

Thanks

Jim
Change the format of a text box or other control on a form or report when it meets certain criteria
Open the form in Design view or Form view or the report in Design view.
1.. Make sure that the control is selected, and then, on the Format menu, click Conditional Formatting.
Do one of the following:
a.. To use values in the selected control as the formatting criteria, click Field Value Is in the first box, click the comparison phrase in the second box, and then type a value in the third (and fourth) box. You can enter a constant value or an expression.
b.. To use an expression as the formatting criteria (to evaluate data or a condition other than the values in selected controls), click Expression Is in the first box, and then enter the expression in the second box. The expression must return a logical value of TRUE or FALSE. Learn about creating an expression.
 
HI,
In report design view, select the text box, from the menu above select
Format | Coditional Formatting. You may also be able to code some more
complicated conditions using the OnFormat event of the section you're
working with.
Regards

I'm trying to have a report display text boxes in different colors based on
simple selection criteria. Ideally, I'd have a separate table containing
the color choices / criteria, but can accept alternate methods.

I've seen several posts about changing color attributes, and have checked
the Access Help screen. The use of "Contitional Formatting" sounds like it
may do the trick for me, but I must be overlooking something, as I can't
find "Conditional Formatting" anywhere on my Design View control menus.

I'd apprecitate any help. Either:
1- Where do I find Conditional Formatting? How to use?
2- Alternate methods to change colors based on selection criteria.

I'm using Access2000. I've done some limited work with Access code writing.
Not my forte.

Thanks

Jim
Change the format of a text box or other control on a form or report when it
meets certain criteria
Open the form in Design view or Form view or the report in Design view.
Make sure that the control is selected, and then, on the Format menu, click
Conditional Formatting.
Do one of the following:
To use values in the selected control as the formatting criteria, click
Field Value Is in the first box, click the comparison phrase in the second
box, and then type a value in the third (and fourth) box. You can enter a
constant value or an expression.
To use an expression as the formatting criteria (to evaluate data or a
condition other than the values in selected controls), click Expression Is
in the first box, and then enter the expression in the second box. The
expression must return a logical value of TRUE or FALSE. Learn about
creating an expression.
 
Back
Top