Solved input mask report and print

[Akai90]

i have 2 value to show on single textbox if null

1. PsPortGuru
2. NoKP

i using query to combine 2 value if one of that null

my query is

compass: Nz([PsPortGuru];[NoKP])

on report i use "compass"

now my problem is for NoKP i want to show input mask

999999\-99\-9999;;_

by using this query

compass: Nz([PsPortGuru];[NoKP])

is there any way i can u input mask above for "NoKP" value only
no input mask if "PsPortGuru" value show

thanks hope understand

 

[arnelgp]

change "compass" in your query to:

compass: Nz([psportguru],Format([nokp],"999999-99-9999"))

 

[Akai90]

it show like this

 

[arnelgp]

ok, change it to:

compass: Nz([psportguru],Format([nokp],"@@@@@@-@@-@@@@"))

 

[Akai90]

ok, change it to:

compass: Nz([psportguru],Format([nokp],"@@@@@@-@@-@@@@"))

its wroking tq...