Blank values with expression?

[#1]

Hi,

I have straight table. I would need to show the values which have 'Instructions' with blanks

I used the below expression.

=If(Instruction='',Instruction)

will it gives the values only with blanks?

[#2]

Sorry please find attached.

[MK_QSL · Accepted solution]

please check...

[MK_QSL]

Also, if you want ID having NULL instruction...use below expression in list box expression...

=IF(LEN(TRIM(Instruction))=0,ID)

[#5]

Thanks. That's perfect.