[AccessD] Conditional Formatting

I would advise paging down.  Then a page at a time of records are displayed, and the formatting 
thing can do its job.

John W. Colby
www.ColbyConsulting.com


Max Wanadoo wrote:
> Yes, but why would you want to?  If it had to process each line while
> scrolling it  could become very  s.l.o.w.  When scrolling it is usually to
> get to another record and not  to  view each one via the scroll  bar. - we
> have the navigation stuff  for viewing each record  in slow mode.
> 
> Max
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: 05 January 2010 22:01
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Conditional Formatting
> 
> Hi Tony - I don't know of any way to refresh the fields while the form is
> still scrolling.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Tuesday, January 05, 2010 3:12 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Conditional Formatting
> 
> 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.
>>>
>>>
>>>    
>>>
>