Discussion on:

Keep users up to date with an Access form marquee

Excellent suggestion. I will put this into all of my applications in the future.

I added a little code to test for a value on the form but I want the marquee to disappear after a few seconds. How do you get the marquee to disappear when it stops moving to the left?

Thanks.

LDN

I may be missing the point here but I question the practicality of this suggestion.

If each user has his or her own copy of the frontend (as they should in the case of the recommended FE/BE architecture) then changing the content of the marquee means that you would have to edit each of the copies of the frontend or push out a new frontend to all users. That would work out to roughly two edits whenever you want to have a marquee message (once to add it, and once to remove it.

I hope you are not suggesting that all users share a common frontend (or even a single unsplit database because that is just a plain bad idea just asking for the database to go down in the flames of corruption,

Glenn
2007, 2008 Access MVP

In Access 2007 I find this code generates an error.
Run-time error '2100':
The control or subform contrl is too large for this location


Try this:
If Label24.Left InsideWidth Then
Label24.Left = Label24.Left + 20
Else
Label24.Left = 0
End If

I need marquee text show fields from a table i can use ADO to get data but how can I put it in the marquee and show recordset after another
thanks