why can't I - backcolor

  • Thread starter Thread starter mark r
  • Start date Start date
M

mark r

I don't understand why A responder to a previous post said
you can't do this with backcolor:

you can't make differential background colors for fields.
What you CAN do,
though, is to make differential forecolor fields. To do
this you will need
to overlap 3 fields:

1) first one- make it invisible; this field will have its
controlsource
property tied to the real underlying field
2) second field- make its control source property:
IIF(isnull(firstrecord), "", [firstrecord]))
Set this one to a transparent backstyle.
3) third field- make its control source property:
IIF(isnull(firstrecord), [firstrecord],""))
Set this one to a transparent backstyle.

This may work for you...
 
Mark:

Stop posting new messages all over the place. If you have a response to a
message, please tie it to that record. Use the "reply to group" feature.

Rick B


I don't understand why A responder to a previous post said
you can't do this with backcolor:

you can't make differential background colors for fields.
What you CAN do,
though, is to make differential forecolor fields. To do
this you will need
to overlap 3 fields:

1) first one- make it invisible; this field will have its
controlsource
property tied to the real underlying field
2) second field- make its control source property:
IIF(isnull(firstrecord), "", [firstrecord]))
Set this one to a transparent backstyle.
3) third field- make its control source property:
IIF(isnull(firstrecord), [firstrecord],""))
Set this one to a transparent backstyle.

This may work for you...
 
Why not just use conditional formatting?


I don't understand why A responder to a previous post said
you can't do this with backcolor:

you can't make differential background colors for fields.
What you CAN do,
though, is to make differential forecolor fields. To do
this you will need
to overlap 3 fields:

1) first one- make it invisible; this field will have its
controlsource
property tied to the real underlying field
2) second field- make its control source property:
IIF(isnull(firstrecord), "", [firstrecord]))
Set this one to a transparent backstyle.
3) third field- make its control source property:
IIF(isnull(firstrecord), [firstrecord],""))
Set this one to a transparent backstyle.

This may work for you...
 
The tone of your "directive" is condescending, assumptive,
and haughty, not to mention oblivious, inconsiderate, and
numb.

It will probably come as a shock to you that many of
you "experts" that respond to those seeking insight and
help do so in quite an incomplete, unenlightening, and
often cryptic manner.

If the "original question" of my original thread, is
responded to by someone who responds incompletely and
cryptically, without responding fully to the essence of my
question, then my question ultimately goes unanswered,
because others will see the thread was responded to and
therefore not add further comment.

I have tried in the past to reply to the cryptic messenger
and ask for more enlightenting explanations, but
invariably they just don't have empathy.

Posting a new message produces a new responder and another
shot at getting a response from a more empathetic person.

As for the response YOU gave to my question, you never
answered my actual question. It went completely over your
head. All you suggested was what to use conditional
coding. That wasn't what I was looking for. I didn't ask
for an alternative method. I asked whether the advice the
other responder gave me was sound or not sound, and WHY. I
wanted to learn about backcolor, what differential meant,
and about why forecolor would be more flexible than
backcolor. And even if that reponder was totally
nonsensical, your suggestion about conditional formatting
is incomplete. Obviously, if I knew about conditional
formatting, I either would have already used it or I would
have no idea of where to apply the concept or I would have
done it already.

Are you paid to reply to questions? Or do you do it just
for the power trip?
 
Mark, you shouldn't be so thin skinned. If you had kept the respons
with the original group of posts then maybe someone would understan
what you are talking about. Although you are right in that if I see
response already made to a question I will not look at it.

What do you mean by differntial colors, I have never heard the ter
before. Do you mean you want a different color for the background o
foreground based upon some criteria?
 
Back
Top