NZ question

[gripper]

I have a form "Transaction Detail" At the top in the form header I have a text box and in the properties under control source I have the following

=Nz([txtSubject_ Property],"Untitled")

I am trying to get the data in the txtSubject_Property box to show up at the top as a record label. I copied this from another DB and tried to adapt it. Currently the only thing that shows up is ?name. I doubled checked my naming and it is fine. My syntax is off somehow or perhaps there is another solution that is better.

It is not working I would love some advice for correcting it.

I want to also go one step futher and also add the data in the txtCity field as well.

So it should look like example "1234 Main Street, Sacramento" when the record is opened.

Thank you very much

 

[Joe4]

I would recommend using the NZ function in a calculation in a Query (instead of directly in the Form). Then use this Query as the source of your Form (and subsequent Text Boxes in the form).

 

[Xander117]

=Replace("txtbox |","|",Nz([txtbox]," (New)")) This is what I use, it displays what I have in the txtbox, and if its a new record it displays "New". The "txtbox" of course gets replaced with whatever field on the form you are trying to display.

 

[gripper]

Xander,

How would I use two text boxes. This first on is the subject property (ie; 1234 Main street) then I want to add a comma (,) then a space and then add the info in the txtCity box (ie: Sacramento) So when all is done it will look like "1234 Main Street, Sacramento"

Thank you

 

[Joe4]

Once again, I would recommend doing the calculation in a query, i.e.
MyAddress: Nz([txtSubject_ Property],"Untitled") & ", " & [txtCity]

 

[gripper]

That did the trick. Thank you very much

 

[boblarson]

Just to let you know that the likely problem when used in the text box directly is that if you have a formula of any type, NZ included, you MUST make sure that the text box is NOT named the same as the field. The default when using the wizard to create the report or form is that it names the controls the same name as the field and if the bound field is used then there is no problem. But, if you use anything that starts with an equals sign, then you must make sure to change the control name and not use it in the formula, but use the field instead (at least on a report).