Scrolling (marquee) Tect

[Commish]

I have a form in Access 2007 - and along the bottom, I want to add
scrolling text - like a News Ticker.

I don't need to display hard coded, static text, I want to use the
results of a query - a query that chooses the 10 highest (most recent)
values. I can create the query easily, and display it in a datasheet.

But is there an easy way to have this scrolling along the bottom of an
existing form?

 

[Arvin Meyer [MVP]]

Try this:

http://www.datastrat.com/Download/Scroll.zip

 

[Commish]

Try this:

http://www.datastrat.com/Download/Scroll.zip

That's a good start - I can see that there's an Event Procedure
associated with the On Timer event. Looking at the code, you've got it
set to text. If I replace the text with [query].[field] - will this
cycle through the records in the query?

 

[Arvin Meyer [MVP]]

Try this:

http://www.datastrat.com/Download/Scroll.zip

That's a good start - I can see that there's an Event Procedure
associated with the On Timer event. Looking at the code, you've got it
set to text. If I replace the text with [query].[field] - will this
cycle through the records in the query?

=================
No. You need to build a loop to cycle through the records and concatenate
them into a long string. Then use that string in the code.