combing two text box values into one label

[mike02]

I have two text boxes, and i want to make there value be the label for the form. Here is what i have in the Label on the form:

=Nz([Last Name] And [First Game],"Untitled")



Where am i going wrong?

Thanks,

[Bob Fitz]

You would need to set the "Caption" property of the form or a label on the form using the forms On Current event. Perhaps something like:
Me.Caption =Nz([Last Name] & " " & [First Name],"Untitled")

[mike02]

I didnt need to set any caption property, i just used your syntax in the formula and it worked like a charm!

Thanks!

[Bob Fitz]

I didnt need to set any caption property, i just used your syntax in the formula and it worked like a charm!

Thanks!

So where exactly did you use the expression. I'm just curious.

[mike02]

in a Label, I have a combo box searching on the Form, and I wanted a Label On the header of the form that brought up the Name of the Client:

[ LastName , FirstName ] (Label)

This is the formula i just typed in the label:

=Nz([Last Name] & "," & [First Name],"Untitled")

[Last Name] and [First Name] are Text boxes on the form. So when i search it takes the value in each text box and puts them together in the Label

[Bob Fitz]

For the benefit of any others that read this thread:
In Access versions up to and including A2003 it is not possible to use an expression like this directly in the label. The way to do it was to set the labels caption property, usually in one of the forms events (e.g. On Current)