Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Flashing Text < Many to Many | DMax >
Back to Flashing Text    Comments List
flashing textbox Upload Images   Link   Email  
Brian Deluna      
3 years ago
I am a silver member. I watched the extended cut video on how to create flashing field in a continuous form. I did apply it on the tick box command but I failed.

Could you please help me make a vba to make a text box flashing from a tick command.

Let say the text box name is "LIVE'. It should flash when a tick box name "check23" will be ticked and flash off when "check23" unticked.

Really appreciate your help mate.

Thank you.

Richard Rost             
3 years ago
That's covered in the Extended Cut for Flashing Text. You just need to add an If/Then condition based on the value of your CHECK BOX (not "tick" box).
Brian Deluna      
3 years ago
Richard this is the original VBA I made in a continuous form, it did function, however when I untick the LIVE checkbox in  one row of the continuous form it also affect the other rows.

Private Sub Form_Timer()
If LIVE= -1 Then
Richard Rost             
3 years ago
Please take a minute to read the Rules for Posting. Don't copy and paste 50 lines of code here asking for us to troubleshoot it. After taking a brief look at it, you may be running into trouble with the word LIVE. Put brackets around it, or try changing it to something that's not a reserved word. It's not on the official reserved words list, but I'm not sure it's allowed either. Also, don't check for -1 with your values. Use TRUE and FALSE, or at least 0 and <>0. Don't rely on -1. Also if LIVE is a text box, it might be TEXT in the box, not a numeric value. I can't tell without seeing your database.
Brian Deluna      
3 years ago
Hi Richard sorry about it. The LIVE is a check box and it should trigger a textbox to flash when that LIVE will be ticked and unticked. It did not work mate because I am not sure on the conditional formatting. Thanks
Richard Rost             
3 years ago
I would recommend learning about Conditional Formatting first then. This (the flashing text in a continuous form) is NOT an easy topic. If you're not well versed in these concepts already, you're going to have trouble with it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Flashing Text.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/13/2024 11:58:18 PM. PLT: 1s