Connecting Tech Pros Worldwide Forums | Help | Site Map

One column flashing on continous form

Randy Harris
Guest
 
Posts: n/a
#1: Nov 12 '05

Strange problem on A2K. A continuous form is getting some sort of strobe
effect on several systems that have been upgraded to Windows XP (never saw
the problem on Win2K). One of the text boxes is flashing the contents.
Users are calling it "Slot Machine Mode". Anyone ever run into something
like this?

Any suggestions appreciated.



Allen Browne
Guest
 
Posts: n/a
#2: Nov 12 '05

re: One column flashing on continous form


Could be a problem with conditional formatting:
http://allenbrowne.com/bug-05.html

A2003 also has this display problem on WinXP:
http://allenbrowne.com/ser-46.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <randy@SpamFree.com> wrote in message
news:fbXnc.33$uL5.9@newssvr33.news.prodigy.com...[color=blue]
>
> Strange problem on A2K. A continuous form is getting some sort of strobe
> effect on several systems that have been upgraded to Windows XP (never saw
> the problem on Win2K). One of the text boxes is flashing the contents.
> Users are calling it "Slot Machine Mode". Anyone ever run into something
> like this?[/color]


CDB
Guest
 
Posts: n/a
#3: Nov 12 '05

re: One column flashing on continous form


I have experienced problems like this with multi-sub forms (migrated from
A97), where the auto-recalculate keeps cycling through...

Fixed by dropping calculated controls on the main form and using code to
update other subs.

Clive


"Randy Harris" <randy@SpamFree.com> wrote in message
news:fbXnc.33$uL5.9@newssvr33.news.prodigy.com...[color=blue]
>
> Strange problem on A2K. A continuous form is getting some sort of strobe
> effect on several systems that have been upgraded to Windows XP (never saw
> the problem on Win2K). One of the text boxes is flashing the contents.
> Users are calling it "Slot Machine Mode". Anyone ever run into something
> like this?
>
> Any suggestions appreciated.
>
>[/color]


Randy Harris
Guest
 
Posts: n/a
#4: Nov 12 '05

re: One column flashing on continous form


Allen, I think you nailed it with the conditional formatting. But, I can't
figure out what to do to stop it. The formatting is pretty simple, if a
certain field (not the control source for the misbehaving control) contains
"(cont)" then change the background color of the control.

Is there some means of working around this, or must I simply shut off the
conditional formatting? I hate to remove a feature that the users have
gotten accustomed to.

The app is developed in A2K and there appears to be no problem until it is
run in A2K3.


"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:40a04c36$0$16606$5a62ac22@freenews.iinet.net. au...[color=blue]
> Could be a problem with conditional formatting:
> http://allenbrowne.com/bug-05.html
>
> A2003 also has this display problem on WinXP:
> http://allenbrowne.com/ser-46.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Randy Harris" <randy@SpamFree.com> wrote in message
> news:fbXnc.33$uL5.9@newssvr33.news.prodigy.com...[color=green]
> >
> > Strange problem on A2K. A continuous form is getting some sort of[/color][/color]
strobe[color=blue][color=green]
> > effect on several systems that have been upgraded to Windows XP (never[/color][/color]
saw[color=blue][color=green]
> > the problem on Win2K). One of the text boxes is flashing the contents.
> > Users are calling it "Slot Machine Mode". Anyone ever run into[/color][/color]
something[color=blue][color=green]
> > like this?[/color]
>
>[/color]


Allen Browne
Guest
 
Posts: n/a
#5: Nov 12 '05

re: One column flashing on continous form


From memory, it is the combination of calculated controls and conditional
formatting that is deadly, as they seem to trigger each other.

AFAIK, there is no real fix for the problem. You could try basing the form
on a query and putting the calculation into the query (as a calculated
field) instead of the ControlSource of the text box, to see if moving it
back a level takes you out of the loop.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <randy@SpamFree.com> wrote in message
news:xNYnc.17970$tW5.6544@newssvr31.news.prodigy.c om...[color=blue]
> Allen, I think you nailed it with the conditional formatting. But, I[/color]
can't[color=blue]
> figure out what to do to stop it. The formatting is pretty simple, if a
> certain field (not the control source for the misbehaving control)[/color]
contains[color=blue]
> "(cont)" then change the background color of the control.
>
> Is there some means of working around this, or must I simply shut off the
> conditional formatting? I hate to remove a feature that the users have
> gotten accustomed to.
>
> The app is developed in A2K and there appears to be no problem until it is
> run in A2K3.
>
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
> news:40a04c36$0$16606$5a62ac22@freenews.iinet.net. au...[color=green]
> > Could be a problem with conditional formatting:
> > http://allenbrowne.com/bug-05.html
> >
> > A2003 also has this display problem on WinXP:
> > http://allenbrowne.com/ser-46.html
> >
> > "Randy Harris" <randy@SpamFree.com> wrote in message
> > news:fbXnc.33$uL5.9@newssvr33.news.prodigy.com...[color=darkred]
> > >
> > > Strange problem on A2K. A continuous form is getting some sort of[/color][/color]
> strobe[color=green][color=darkred]
> > > effect on several systems that have been upgraded to Windows XP (never[/color][/color]
> saw[color=green][color=darkred]
> > > the problem on Win2K). One of the text boxes is flashing the[/color][/color][/color]
contents.[color=blue][color=green][color=darkred]
> > > Users are calling it "Slot Machine Mode". Anyone ever run into[/color][/color]
> something[color=green][color=darkred]
> > > like this?[/color][/color][/color]


Closed Thread


Similar Microsoft Access / VBA bytes