consitional formatting of time

[infoscion]

Hello:
I am trying to format a text box. Incase the time is bigger than a certain window (7:00 AM-5:00 PM), I want it to be indicated in some different color. How do I accomplish this using the conditional formatting made available in Access2k?
Suggestions and ideas are solicited.
Regards,
Info

 

[TheAceMan1]

How are ya infoscion . . . . .

[blue]Incase the time is [purple]bigger[/purple] than a certain window (7:00 AM-5:00 PM)[/blue]

Hmmmmmmm . . . . do you really mean non-inclusive in 7:00 AM-5:00 PM)?

See Ya! . . . . . .

 

[infoscion]

The default value for the text box is 12:00 PM.I want it to be highlighted in red when the default value is indicated in the text box. Once the user enters any other value the font color should be black.
Regards,
Info

 

[flyover789]

is this on an endless form or on a continuous form?

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database Systems and Applications across all Business Areas[/blue]

 

[flyover789]

sorry, I meant a single or a continuous form (you won't need conditional formatting on a single form)

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database Systems and Applications across all Business Areas[/blue]

 

[infoscion]

Hi:
This is a continuous form. Also with some code,

if Me.text0.value=svalue then
me.text0.forecolor=vbred

Now it is working.
Thank you very much for your help.
Many Thanks
Info