Hi Guy's
         I having an report in which i gon an data lable , in that it may not having data for some time so i would like it to apppear like -- or "Nill". How can make this in the Ms Access

 Pls clarify my Probs,

 thanks & Regards.,
 Pap:)

You need to check the field that is empty, and then set the label text as a condition of the field value. I think this is what you want to do. So on the form's Detail section On Format event, you might put:

'-----

If IsNull(Me.TextBox) Or Me.TextBox = "" Then
   Me.DataLabel.Text = "--"
   Else
   Me.DataLabel.Text = "Your Value Here"
End If

'-----

Does this work? I know other posters might have a more elegant way to do this, but no one has posted yet.

HTH


mmcdonal

Hi donal,

  I got ur idea but iam not able to do the function .I want this "----" text should appear in the report .

P.A.P.Raguv

Okay, here is another idea:

In the detail of your report, put an unbound label, and add the text to that label that you want. ---

Then put this code in the Detail section's On Format event:

'-------------

If IsNull(Me.YourTextBoxName) Or Me.YourTextBoxName = "" Then
   Me.YourTextBoxName.Visible = False
   Me.Your---LabelName.Visible = True
   Else
   Me.YourTextBoxName.Visible = True
   Me.Your---LabelName.Visible = False
End IF

'-------------

I know this will work. Please understand that when I use "Me.YourTextBoxName" I am using a generic name and you must supply the actual name of the field that you want to appear or disappear. The same with "Me.Your---LabelName". That will be called "Label11" for example.

HTH



mmcdonal