A different conditional formatting problem in Access 2003

Here's a problem I haven't seen discussed.

I have a continuous form with a conditional format for the background color
of a text box. It had been working fine until I upgraded to Access 2003 SP3.
Now, with no other changes, the color change for condition 1 doesn't work.
Instead, the color displayed is my default color. Conditions 2 and 3 work as
they always have. Has anyone seen this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200711/1

Re: A different conditional formatting problem in Access 2003

I'm certainly disappointed in the complete lack of help from the group.
Fortunately, I found a fix myself. I deleted all of the conditional formats
from the form and then re-entered them. I don't know why, but that fixed the
problem.

vircalendar wrote:
>Here's a problem I haven't seen discussed.
>
>I have a continuous form with a conditional format for the background color
>of a text box. It had been working fine until I upgraded to Access 2003 SP3.
>Now, with no other changes, the color change for condition 1 doesn't work.
>Instead, the color displayed is my default color. Conditions 2 and 3 work as
>they always have. Has anyone seen this?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200711/1

Re: A different conditional formatting problem in Access 2003

"vircalendar via AccessMonster.com" wrote in
news:7b9fb8e701857@uwe:

> I'm certainly disappointed in the complete lack of help from the
> group. Fortunately, I found a fix myself. I deleted all of the
> conditional formats from the form and then re-entered them. I don't
> know why, but that fixed the problem.
>
> vircalendar wrote:
>>Here's a problem I haven't seen discussed.
>>
>>I have a continuous form with a conditional format for the background
>>color of a text box. It had been working fine until I upgraded to
>>Access 2003 SP3. Now, with no other changes, the color change for
>>condition 1 doesn't work. Instead, the color displayed is my default
>>color. Conditions 2 and 3 work as they always have. Has anyone seen
>>this?

I'm sorry. I should have replied, "Yes, you have seen it, or so it must
be, if I am to believe you." But then I noticed you were posting "via
Access Monster" and I asked myself, "How much faith do you have in a
poster from a site that makes money by posting the freely-given answers
of developers like me, here in CDMA, without any indication that the
posters of these answers have nothing to do with Access Monster?

Example below:

************
>A97.
[quoted text clipped - 3 lines]
> Many thanks.
> Keith.

DAO.DBEngine(0)(0).Execute "ALTER TABLE " _
& "[D:\My Documents\Access\db1.mdb].tbl2002Transactions " _
& "ALTER COLUMN fldDescription TEXT"

Changes field type from binary to text.

Signature

Lyle

*************

This commercial site, which you use, posted my code, has posted thousands
of examples of my code, without any compensation, without any indication
that I have nothing to do with Access Monster. I consider this to be
highly unethical.

If you were a regular poster here I might have considered at least
looking at a form to see if I could duplicate your problem. But on the
day I read your post there were other questions posted in CDMA, not
asking the ridiculous, "Has anyone seen this?", but carefully worded and
thought-out, that I could answer, from genuine CDMA posters; some of
these posters had actually contributed an answer in the past. I apologize
for spending my free time answering intelligent questions here in CDMA
and ignoring your rather stupid question, posted in a slurper.

Hope this helps!


--
lyle fairfield

I will arise and go now,
For always night and day
I hear lake water lapping
With low sounds by the shore;
While I stand on the roadway
Or on the pavements gray,
I hear it in the deep heart's core.
- Yeats

Re: A different conditional formatting problem in Access 2003

vircalendar via AccessMonster.com wrote:

> I'm certainly disappointed in the complete lack of help from the group.

Are you a troll or an whiney baby?

Re: A different conditional formatting problem in Access 2003

Very well said, Lyle.

lyle fairfield wrote in
news:3Lv1j.15924$xa2.2556@read2.cgocable.net:


> "vircalendar via AccessMonster.com" wrote in
> news:7b9fb8e701857@uwe:
>
>> I'm certainly disappointed in the complete lack of help from the
>> group. Fortunately, I found a fix myself. I deleted all of the
>> conditional formats from the form and then re-entered them. I
>> don't know why, but that fixed the problem.
>>
>> vircalendar wrote:
>>>Here's a problem I haven't seen discussed.
>>>
>>>I have a continuous form with a conditional format for the
>>>background color of a text box. It had been working fine until I
>>>upgraded to Access 2003 SP3. Now, with no other changes, the
>>>color change for condition 1 doesn't work. Instead, the color
>>>displayed is my default color. Conditions 2 and 3 work as they
>>>always have. Has anyone seen this?
>
> I'm sorry. I should have replied, "Yes, you have seen it, or so it
> must be, if I am to believe you." But then I noticed you were
> posting "via Access Monster" and I asked myself, "How much faith
> do you have in a poster from a site that makes money by posting
> the freely-given answers of developers like me, here in CDMA,
> without any indication that the posters of these answers have
> nothing to do with Access Monster?
>
> Example below:
>
> ************
>>A97.
> [quoted text clipped - 3 lines]
>> Many thanks.
>> Keith.
>
> DAO.DBEngine(0)(0).Execute "ALTER TABLE " _
> & "[D:\My Documents\Access\db1.mdb].tbl2002Transactions " _
> & "ALTER COLUMN fldDescription TEXT"
>
> Changes field type from binary to text.
>
> Signature
>
> Lyle
>
> *************
>
> This commercial site, which you use, posted my code, has posted
> thousands of examples of my code, without any compensation,
> without any indication that I have nothing to do with Access
> Monster. I consider this to be highly unethical.
>
> If you were a regular poster here I might have considered at least
> looking at a form to see if I could duplicate your problem. But on
> the day I read your post there were other questions posted in
> CDMA, not asking the ridiculous, "Has anyone seen this?", but
> carefully worded and thought-out, that I could answer, from
> genuine CDMA posters; some of these posters had actually
> contributed an answer in the past. I apologize for spending my
> free time answering intelligent questions here in CDMA and
> ignoring your rather stupid question, posted in a slurper.
>
> Hope this helps!
>
>
So well said it deserves repeating.

Very well said, Lyle.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Re: A different conditional formatting problem in Access 2003

On Fri, 23 Nov 2007 03:31:36 GMT, "vircalendar via AccessMonster.com"
wrote:

>I'm certainly disappointed in the complete lack of help from the group.
>Fortunately, I found a fix myself. I deleted all of the conditional formats
>from the form and then re-entered them. I don't know why, but that fixed the
>problem.


You certainly have a right to be disappointed. Nobody bothered to
answer your question. If I were you, I would take my business
elsewhere and refuse to post any more questions on this newsgroup.

Re: A different conditional formatting problem in Access 2003

"vircalendar via AccessMonster.com" wrote in message
news:7b9fb8e701857@uwe...
> I'm certainly disappointed in the complete lack of help from the group.

Experience is what you get when you don't get what you want.

> Fortunately, I found a fix myself. I deleted all of the conditional
> formats
> from the form and then re-entered them. I don't know why, but that fixed
> the
> problem.

See?

Incidentally, the fact that your fix worked is suspicious. You could have
some corruption in your file. If I were you I'd import everything into a new
file, then run with that. Anything that won't copy you can bet is messed up,
and will need to be either restored from backup or re-created.

Re: A different conditional formatting problem in Access 2003

"lyle fairfield" wrote

> I apologize for spending my free time answering
> intelligent questions here in CDMA and ignoring
> your rather stupid question, posted in a slurper.

Oh, me, oh, my... are you saying that "Something went wrong somewhere. What
do I do?" doesn't qualify as an intelligent question? :-)

Interesting to me why anyone would use a "gateway site" like that to access
newsgroups. I suppose if I would log in at one or two of them, I might
discover their attraction, but it seems such a waste of time.

Larry