Textbox Visablilty False or True

Snoddans

I have this one problem I am hoping someone can clear up for me. The thing is that I have deployed a number of textboxes on a report, and I would like to include in a conditional statement that if anouther value of another textbox is NULL, then the textbox´s visability becomes False! I have tried some methods, that is using a loop because the values are set in arrays, but it doesn´t seem to work

Lars_Westman

You can't set individual controls as visible or not in a report as You can do in a form. What You can do in the report is to set the varialbes source to '' or zero and to make whole sections visible or not.

If it's at label You whant to control the visibility for i suggest You use a textbox instead and set the source in the code.

//Lars

John_Tegelaar

Textboxes on a report have the properties BlankNumbers and BlankZero. The first one lets you chose from several settings (i.e. show positive numbers, but blank negative), the other one simply blanks out 0 and No values.

John

Dave_Cox

If your report is just a veiwing report and does not have any modify code like the Sales Document Printing which modifies the "No. Printed"

you can conditionally code on after get record trigger
IF "Job Value" = 0 THEN
JobDesc:=''
Else
JobDesc:='Services Charge for Job '+"Job No.";

IF "Job Value" = 0 THEN
"Job No.":='';

Removes the "Job No." for the record and report output this run.

WARNING:
Use A variable for reports that Modify if you are changing field values.
IF "Job Value" = 0 THEN
JobNo:=''
ELSE
JobNo:="Job No.";

Have Fun

Paste an example of your code if this does not help you!

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

[This message has been edited by Dave Cox (edited 27-03-2001).]