Need to generate a text warning on a form by date due

[Brainwave Surfer]

Dear All,
I have a form that tracks several dates that need to have messages flash
up on the screen in a corner. I've experimented with the conditional
formatting to make messages grey out or flash red, but the sheer number
of dates involved rules that out, since the list would be cumbersome,
and Orc-ugly...

Is there a way to fill out a box of either message box or text box, and
generate the text within? Part of my problem is what does Access call
that? ;-)

Jim

 

[Gordon Dale]

Try MsgBox

Regards

Gordon

 

[mikebres]

-----Original Message-----
Dear All,
I have a form that tracks several dates that need to have messages flash
up on the screen in a corner. I've experimented with the conditional
formatting to make messages grey out or flash red, but the sheer number
of dates involved rules that out, since the list would be cumbersome,
and Orc-ugly...

Is there a way to fill out a box of either message box or text box, and
generate the text within? Part of my problem is what does Access call
that? ;-)

Jim
.

Jim, you can address the caption in a label just like any
other control i.e. you have a label named "CritDate" on
form named "ImportantDates". Then you can assign it a
new value:

Forms!ImportantDates!CritDate.Caption = "Look At Me!"


Try this to see and example. Create a new form. Add a
label to the form and name it CritDate. Now add a new
command button. Right click the button and select Build
Event. Add in the code below. Then open the form and
click the command button.

Private Sub Command1_Click()
Me.CritDate.Caption = #2/7/2004#
Me.CritDate.BackStyle = 1
Me.CritDate.BackColor = 255
Me.CritDate.ForeColor = 16777215

End Sub

 

[Brainwave Surfer]

Many thanks, Gordon and Mike...

I wound up using: lblFollowUp.Caption = "Yucca2"

and it works like gangbusters!!!!!

Many thanks.