[AccessD] Conditional Formatting

David McAfee davidmcafee at gmail.com
Tue Jan 5 16:48:09 CST 2010


I wonder if he did it the old, A97 way, if it would work better.



On Tue, Jan 5, 2010 at 2:18 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> 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.
>>>>
>>>>
>>>>
>>>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list