None Value

Horse06

Hi Expert, I have a text field and sometimes it has value, but sometimes it does not.
How to use the if condition. If there is no value, display it as "NONE", otherwise display the values. Appreciate it!

Horse06

This is for a report!

Savatage

If yourtextfield = '' then myvaluefield ='none'
Else myvaluefield = whatever

Is this what your talking about?

Horse06

Hi Harry Thank you for your respose! I am using the same coding which I posted a few days ago here, but the system kept on giving the value of None even if it has values. Please advise!

Alex_Chow

IF TextValue = '' then
  TextValue := 'None';

This code will work. If not, you're doing somethng wrong.

Savatage

also you can add a test line like...
message('%1',mytextvalue);

to show what the value is and that your actually getting one.

If flowfield try calcfields first

Administrator

[Topic moved from 'NAV Tips & Tricks' to 'NAV/Navision Classic Client' forum]