Flashing text?

[Laocon]

I currently have a text box that changes colour depending on the data held within...

eg No. of days before a certain event

30+ days = Dark Blue text
10+ days = Dark Red text
5+ days = Bright Red text

Is there anyway I can make it flash as well?

 

[Pat Hartman]

Most people find flashing text to be annoying. To do it with Access, you need to use the timer event to alternate some property of the text box.

 

[LQ]

If you are set on having it flash, despite Pat's advice, you can, as suggested, use the form's timer event and do something like this:

Private Sub Form_Timer()

' Let's make the label flash when a filter
' has been applied so the user knows a filter
' is being used.
If Me.Filter <> "" Then
' Find out what the current color is
' and change it to the other color
' so it looks like the label is flashing.
If Me.lblFilter.ForeColor = 0 Then
Me.lblFilter.ForeColor = 255
Else
Me.lblFilter.ForeColor = 0
End If
' Change the caption.
Me.lblFilter.Caption = "FILTERED"
Else
' No filter exists so make the label static.
Me.lblFilter.Caption = "UnFiltered"
Me.lblFilter.ForeColor = 0
End If

End Sub

I used this to let users know if a filter was on or not, but you could easily adapt the if...then statement to your needs.

HTH
LQ

 

[H]

hey i cant help you sorry, but can you help me, how do you get the text box to change colour.

thank you

 

[Laocon]

Thanks - I will try that... I want it to be annoying because it is a reminder on a switchboard that the user has to do something within a certain time frame!!

Here's the code I am using to change the colour of the text...

I am putting it in the OnCurrent EVENT...

Calculated…
If (Now + 5) >= (Me![SubmitDate]) Then
Me![SubmitDate].ForeColor = 255
ElseIf (Now + 10) >= (Me![SubmitDate]) Then
Me![SubmitDate].ForeColor = 128
ElseIf (Now + 30) >= (Me![SubmitDate]) Then
Me![SubmitDate].ForeColor = 8388608
End If

HTH

[This message has been edited by Laocon (edited 09-04-2001).]

 

[R. Hicks]

One other thing to think about ...........

Flashing objects on screen have been known to trigger "Epileptic Seizures" in people suffering from Epilepsy.

Something to think about .........

BTW ... I also find it very annoying.

HTH
RDH

[This message has been edited by R. Hicks (edited 09-04-2001).]

 

[Fornatian]

If it's something the user HAS to do then it seems you are being far too nice about it,why not just prevent them from continuing until they've done what you need them to?

You can't please all the people all the time but you can please yourself whenever you want.

Ian

 

[Laocon]

Yes - that is an option ultimately Fornation, however Im not that advanced yet...! However, I will look into that option...
Also, since the db is for customers to use it doesn't bother me if they don't forecast - but it'll be a pain for them if they don't, I just want a gentle reminder for them.

As for the text flashing - no I don't want to induce a seizure on anyone, I was thinking more of a gentle pulse, eg 1 second on / 1 second off, rather than a strobe effect...

Thansk again all!