bug with conditional formatting?

[Guest]

I have a textbox that I want to format based on field
value.

The textbox is named: txtAssignedPersonell

The conditional formatting is as follows:

Format=green background, white bold text when greater than
90.

Format=red background, white bold text when less than 80.

Format=yellow background, black bold text when between 80
and 90.

The problem occurs when the value is 100 or more. It will
format the text box with the red background, white bold
text instead of the green.

This textbox is unbound and I assign the value manually in
the PageFooterSection_Format event. (it's in my footer)

What's happening to the formatting???

I'm going to give up and assign the format
programmatically, but wouldn't mind some ideas as to why
this is happening.

 

[Marshall Barton]

I have a textbox that I want to format based on field
value.

The textbox is named: txtAssignedPersonell

The conditional formatting is as follows:

Format=green background, white bold text when greater than
90.

Format=red background, white bold text when less than 80.

Format=yellow background, black bold text when between 80
and 90.

The problem occurs when the value is 100 or more. It will
format the text box with the red background, white bold
text instead of the green.

This textbox is unbound and I assign the value manually in
the PageFooterSection_Format event. (it's in my footer)

What's happening to the formatting???

I'm going to give up and assign the format
programmatically, but wouldn't mind some ideas as to why
this is happening.

It sounds like the field is a text string or the 80 is in
quotes. If that's not it, then try using an Expression with
CLng to make sure the value is treated as a number:
CLnf(textbox) < 80

 

[Wayne Morgan]

It sounds as if your "number" field is defined as a text field.

 

[prabha]

Hi,

This is a bug in versions 2000 and above.

Would need to implement conditional formatting programmatically.

If you have additional questions on this topic, please respond back to this
posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| Content-Class: urn:content-classes:message
| From: <[email protected]>
| Sender: <[email protected]>
| Subject: bug with conditional formatting?
| Date: Wed, 4 Feb 2004 14:53:41 -0800
| Lines: 28
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPrcbv0mnZbCfPER+O1vt9A+cMSwg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.reports:129811
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have a textbox that I want to format based on field
| value.
|
| The textbox is named: txtAssignedPersonell
|
| The conditional formatting is as follows:
|
| Format=green background, white bold text when greater than
| 90.
|
| Format=red background, white bold text when less than 80.
|
| Format=yellow background, black bold text when between 80
| and 90.
|
| The problem occurs when the value is 100 or more. It will
| format the text box with the red background, white bold
| text instead of the green.
|
| This textbox is unbound and I assign the value manually in
| the PageFooterSection_Format event. (it's in my footer)
|
| What's happening to the formatting???
|
| I'm going to give up and assign the format
| programmatically, but wouldn't mind some ideas as to why
| this is happening.
|
|