[AccessD] Conditional Formatting

Tony Septav iggy at nanaimo.ark.com
Tue Jan 5 15:11:35 CST 2010


Hey Dan and Doug
Thank you very much for your responses.
But as I mentioned the only real problem I am having is with the scrolling.
It is the same if you use a calculated field in a continuous form, it 
does not refresh until you stop scrolling. So I do my calculations in a 
query instead or have the calculations as part of the table.

Dan Waters wrote:

>What's happening is that every time you set the background color in
>conditional formatting, the Back Style property of the text box will revert
>to 'Normal', even if you had it set to 'Transparent'.
>
>So do the conditional formatting first, then set the textbox formatting in
>the property list, and then it should look pretty good.
>
>Good Luck!
>Dan
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
>Sent: Tuesday, January 05, 2010 12:13 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Conditional Formatting
>
>As far as my experience goes, your scrolling behaviour is normal.  My
>impression is that the conditional formatting is applied after the form is
>fully loaded.  I had so much trouble with screen flickering in Access 2000
>that I didn't use conditional formatting, but in 2003 it seems to be OK.
>That may just be due to faster processors/graphics cards.
>
>I've also found that it's difficult to keep a conditionally formatted
>textbox transparent - the default always seems to be white.
>
>Doug Steele
>
>On Tue, Jan 5, 2010 at 9:57 AM, Tony Septav <iggy at nanaimo.ark.com> wrote:
>
>  
>
>>What I am finding is
>>Only when I am scrolling up and down.
>>1. If I scroll up or down the form the text boxes do not colour until I
>>stop scrolling.
>>2. Some text boxes when I am scrolling  appear white, while others seem
>>to go transparent (and display the forms detail background colour) until
>>I stop scrolling.
>>3. Sometimes if I delete the old text box and add a new one and
>>duplicate the conditional formatting the text box will appear white, but
>>not always, sometimes it still appears transparent.
>>
>>Is this normal or have I corrupted the form somehow???
>>What I was hoping would happen is the colours would appear while I am
>>scrolling and visually cause me to stop to check out the flag.
>>
>>
>>    
>>




More information about the AccessD mailing list