How conditionally printing a label using Data Report (VB6.0)

[mvmukhedkar]

Respected Sir / Madam,

How conditionally print a label using Data Report (VB6.0)
e.g., if cust_no < 100 display the label &quot;Cust_No : &quot; and actual cust_no otherwise don't display the label as well as the actual value.

The set up is : VB 6.0 (Data Report and Data Environment)
and MS - Access (.mdb files)

Thank you.

Regards

Prasad

 

[Lion3000]

You can do this by write a formula in the Format Editor under object format and suppress section. Enter the formula that you want in order to suppress the label when the formula returns true. Click to the &quot;X+2&quot; button and write: cust_no >= 100 and the same formula for the actual value (database field). I assume that the &quot;cust_no&quot; is a database field, so it would be written as {[db_table_name].cust_no} in the 2 suppress formulas (where &quot;[db_table_name]&quot; is your database table name).