Report IF

[NN]

Hi,

I have a report with a text box (txtNotes), I would like for the label
(lblNotice) to be only visable is there is text in the text box (meaning do
not show lblNotice if txtNotes is blank). I can't figure out the code for
this?

Also is it possible to create a watermark-like label? So you can see the
text boxes and labels that are on top of the label I want to watermark.
Reason being I want *SEE NOTES* is light grey over the invoice contents if
txtNotes has a message in it.

Many thanks in Advance :-)

Nicholas.

[Svetlana]

On format event In the section your label is in try this
If Nz(Me.txtNotes)<>"" Then
Me.lblNotes.Visible=True
Me.lblOther.ForeColor=vbRed
Else
Me.lblNotes.Visible=False
Me.lblOther.ForeColor=vbBlack
End If

[fredg]

On Thu, 22 Jun 2006 04:12:04 GMT, NN wrote:

Hi,

I have a report with a text box (txtNotes), I would like for the label
(lblNotice) to be only visable is there is text in the text box (meaning do
not show lblNotice if txtNotes is blank). I can't figure out the code for
this?

Also is it possible to create a watermark-like label? So you can see the
text boxes and labels that are on top of the label I want to watermark.
Reason being I want *SEE NOTES* is light grey over the invoice contents if
txtNotes has a message in it.

Many thanks in Advance :-)

Nicholas.

In a report?
Code the Detail Format event:
[lblNotice].Visible = Not IsNull([txtNotice])

I'm not sure I follow what you intend the watermark label to do.
To add a label to the report as a 'watermark' create the label. Size
it as needed. Place it where you wish.
Make sure it's BackStyle is set to Transparent.
Click on Format + Send To Back.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail