Blank Field

[scouser]

Is it possible to insert some text into a report field if there is no data?

Let me explain:
There is a field on my Orders Form (Purchase Order). This is not always filled out. When the report is generated from a command button I would like to insert text as opposed to leaving the field blank.

Something along the lines of:

Not Advised

can I you use =IIF(IsNull

Cheers,
Phil.

 

[KenHigg]

Sure - Just do this in the underlying query. Instead of bring down the PO fld, just do something like:

MyNewPOFld: iif(isnull([PO], "Some text", [PO])

Would this work?

kh

 

[scouser]

Cheers

Not quite there (yet!).

I have tried:

PO: IIf(IsNull([PurchaseOrderNumber]),"Not Known " & [PurchaseOrderNumber],"")

'Result: 
'Prints "Not Known" if PO Field is left blank.
'However is there is a value in PO Field it Prints Blank (NO PO!!)

Also tried:
PO: IIf(Not IsNull([PurchaseOrderNumber]),"Not Known " & [PurchaseOrderNumber],"")

'Result: 
'Prints "Not Known" and PO Field Value
'i.e. "Not Known PO15965"

Must be close to nailing this one!!

 

[KenHigg]

PO: IIf(IsNull([PurchaseOrderNumber]),"Not Known ",[PurchaseOrderNumber])

???
kh

 

[scouser]

Success

Nice one Ken. All working.