Solved

Making text box flash when date the is met

Posted on 2008-10-19
3
338 Views
Last Modified: 2013-11-28
I have "date" text box on a Customer Job Report Form. This text box is a Dlookup from the customer field, that gets the contract renewal date from a seperate table. I have added conditional formatting to "date" highlightING when the renewal date is approaching, but would like it to flash when it within 30 days of the current date. Please can you help?
0
Comment
Question by:SparkyP
3 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 22752622
Flashing text is a really big design no-no ... you'd be much better off using conditional formatting to show it in Red, Bold ... whatever would draw attention other than flashing text. Users hate it and unless you provide them some way to turn it off I'd suggest you reconsider.

That said: Is this a continuous or Datasheet form? If so, you can't do it anyway ... if not, you could use the Form's Timer event to do this.
0
 
LVL 33

Expert Comment

by:jppinto
ID: 22752626
0
 

Author Closing Comment

by:SparkyP
ID: 31507605
Thanks for your experience, it seemed a good idea at the time!!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question