Conditional formatting

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I have a field called ReasonPROP. If this field indicates "Dead" I would like
the colour of another field ClientLastName to change to a different colour.
 
Anne

"How" depends on "what" (and "where"). It may just be a matter of semantics
....

In Access, "fields" exist in tables. If you are trying to do this directly
in a table, stop now! Access tables are NOT spreadsheets, they are "buckets
o' data".

Access forms display data. The terminology Access uses for the little
windows through which you see the data is "controls".

Are you working in a form or directly in a table?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
File menu Format -> Conditional Formatting...

change Condition type [Field Value Is] to [Expression Is]
in the expression text box type [ReasonPROP] = "Dead"
make your formatting changes for that condition


In
 
make sure the [ClientLastName] is the field selected when you do this

SuzyQ said:
File menu Format -> Conditional Formatting...

change Condition type [Field Value Is] to [Expression Is]
in the expression text box type [ReasonPROP] = "Dead"
make your formatting changes for that condition


In

Anne said:
I have a field called ReasonPROP. If this field indicates "Dead" I would like
the colour of another field ClientLastName to change to a different colour.
Click to expand...
Click to expand...
 
Yes, I should have used the term control instead of field as well.
Conditional formatting cannot be done on tables nor should it be.
 
I have a field called ReasonPROP. If this field indicates "Dead" I would like
the colour of another field ClientLastName to change to a different colour.
Click to expand...

You can't do this in a Table, but then you shouldn't be looking at tables for
interaction with data anyway. Use a Form.

In the form, select the ClientLastName textbox in form design view and choose
Format... Conditional Formatting from the menu. The menu is pretty clear, post
back if you have trouble.
 
I am working in the work. I tried what you suggested but it didn't work. My
form has several pages. The ReasonPROP field displays on a different tab
than my ClientLastName Field is that the issue?
 
Anne

Since we aren't there and can't see what you're looking at, "I am working in
the work" doesn't help us much.

And since I didn't suggest trying anything, I'm not sure what you tried that
didn't work.

And when you say "didn't work", does that mean nothing happened? ... or
that you got an error message? ... or that the PC turned off? ... or ...?

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Sorry, dyslexic moment - I'm working in the form. I tried what you suggested
but it didn't work. My form has several pages. The ReasonPROP field displays
on a different tab in the form from my ClientLastName Field is that the
issue?
 
Sorry, dyslexic moment - I'm working in the form. I tried what you suggested
but it didn't work. My form has several pages. The ReasonPROP field displays
on a different tab in the form from my ClientLastName Field is that the
issue?
--
Click to expand...

It shouldn't; might it be on a Subform (which *would* make a difference)?

What are the actual names of the controls on the form? What expression are you
using in the codition?
 
I tried Suzy Q's suggestion -
change Condition type [Field Value Is] to [Expression Is]
in the expression text box type [ReasonPROP] = "Dead"
make your formatting changes for that condition

This didn't work.

Then I tried the conditional formatting on the [EndDatePROP] instead and
used is not null. That changes the formatting on my ClientLastName. Why
doesn't the [ReasonPROP] = "Dead" formatting work - I would like to use
different formats forthe different reasons the client is closed so would
prefer the formatting to work on[ReasonPROP]. Any suggestions?
 
I just got it to work. In my table ID 1 = dead, ID 2 = does not fit mandate,
ID 3 = moved out of provinec etc. I used the ID number rather than the
description and it works fine so now I can use different colours for each
reason by adding conditions for each on my box on my form.

Thanks
 
I just got it to work. In my table ID 1 = dead, ID 2 = does not fit mandate,
ID 3 = moved out of provinec etc. I used the ID number rather than the
description and it works fine so now I can use different colours for each
reason by adding conditions for each on my box on my form.
Click to expand...

That's a good example of why many of us DESPISE the "Lookup Field" datatype.
The field appears to contain "Dead" but it doesn't, and that trips you up in
cases like this.
 
Back
Top