is it possible

[antonov]

hello there, is it possible to make the content of a textbox blink if a
certain criteria is met (i.e. if > then a certain value)

thanks

 

[Guest]

While it is likely possible to do this, it may not be so practical. You would
likely need to use a Form_Timer event procedure, which either cycles the
..visible property for the textbox, or cycles to forecolor to match the
backcolor. However, anytime you start using Form_Timer code, you can
introduce a host of other issues that need to be dealt with. A much easier
alternative would be to simply change the font color, using conditional
formatting. Conditional formatting is included in forms and reports starting
with Access 2000, or you can use VBA code in Access 97 to achieve the same
effect. Alternatively, you can use format properties to include changes in
font color:

Conditional Formatting
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________