Stephen Labans, as is frequently the case for matters complicated, has a hack for doing this that requires little in the way of resources, he says...and you can always take him at his word:
http://www.lebans.com/hscroller.htm
Hi Linq. Thanks for the pointer. As I had suspected, it's better to use API for something like this. Good luck!
I've looked at the example database on Stephen's site and, as with all his work, its very clever.
However IMHO its totally over the top for this purpose
It also scrolls text in the Access window title bar NOT the form title bar
The attached example shows how a scrolling form header caption can be achieved using the same code as for marquee text with no API required. Its a borderless form ...so no title bar
Each scroll can be run separately or at the same time.
The scroll speed can also be adjusted to suit user preference.
I doubt the resource overhead is much different in Stephen's example (based on APIs) or this one - the issue in both apps would the side effects of running a form timer whilst doing other form activity
Speaking for myself, a scrolling header or title bar would annoy me intensely .... but if that's what the OP wants ....