View Single Post
  #2 (permalink)  
Old June 11th, 2004, 04:31 PM
Bob Hansen Bob Hansen is offline
Authorized User
 
Join Date: May 2004
Location: , NH, USA.
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Some quick and dirty, untested thoughts:

How about something in the Report Detail section? something like this:
==========================
On Format Event:

If TextBox=0 then Textbox.visible = no.
or
If TextBox=0 then Textbox.Font Color = background color.
======================
Or consider this:
Instead of displaying the payment field, display an unbound field (paymentshadow)with a formula that copies the value of the payment field, unless it is a zero. In that case, make it a null value which should not display.

IIf(Payment=0,@Null,Payment)

You could do this at a query level so that if you have multiple reports based on the same query, you only need to make this field once.
========================================