Solved replace null field to another textbox value (1 Viewer)

[Akai90]

="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & [NOKP] & " )</b>  telah "

above is my current code.

is there another where if i want replace "NOKP" with another fields "PSPORT" if "NOKP" is null

hope you understand

 

[arnelgp]

="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & Nz([NOKP], [PSPORT]) & " )</b> telah "

 

[Akai90]

="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & Nz([NOKP], [PSPORT]) & " )</b>  telah disertakan."

GOT SYNTAX ERROR

 

[arnelgp]

you should put [PSPORT] field in your form, then set the textbox Visible property to No.

 

[Akai90]

you should put [PSPORT] field in your form, then set the textbox Visible property to No.

PROBLEM SOLVED BY USING SQL

comkp: Nz([NOKP];[PSPORT])

 

[arnelgp]

so you use semicolon ( and not comma (,)