Code issue on Format of label

[Gavroche]

Hi all,



In my label, I have a text box that displays the following three fields:

=Trim([Entree] & " " & [Dressing] & " " & [Bread]), all text fields.

I have the following code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtDressingID = 5 Then


I would like the field [dressing] (string) to show nothing. Right now it says "none", but I actually want no characters displayed and I forgot how to do this.

Thank you for all your help

[alansidman]

Try

If Me.txtDressingID = 5 Then
Me.Dressing.Value = ""

[Gavroche]

Thank you Alan,

Unfortunately that didn't work. I had thought of that before. I believe that this the field dressing [dressing] is part of a bigger textbox, the actual code must involve the text box, but I forgot how to do it.

I have tried me.text4.dressing.value = "" etc... to no avail.

Thanks