I dont want a zero value currency field to print.

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
pcsunlimited
Newcomer
Posts: 1
Joined: Tue Jul 10, 2007 7:53 pm

I dont want a zero value currency field to print.

Post by pcsunlimited » Tue Jul 10, 2007 8:02 pm

Hi,

I have a text box linked to a currency field in Access. When there is a value in the field in Access all is fine. However at the moment if the access field is null or empty then NiceLabel prints £0.00 on the label. I would like it if possible to leave the field blank on the label. Any suggestions greatly appreciated.

Paul.

User avatar
lpatty
NiceLabel
NiceLabel
Posts: 60
Joined: Mon Sep 11, 2006 4:15 pm
Location: Milwaukee, WI
Contact:

Post by lpatty » Mon Jul 16, 2007 8:14 pm

You need to evaluate the value in the database to see if there is a value. If not, then set the output field as an empty string, if so, then set the Result value for the field equal to the database field value.

You would have to create a script in that field on the label that would be something like:

If [Table.Field1] = "" Then
Result = ""
Else
Result = [Table.Field1]
End If

Post Reply