Max Wanadoo
max.wanadoo at gmail.com
Tue Jan 5 16:08:47 CST 2010
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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com