This is kind of related to LoraLee's Question. I have a report for insurance coverage. There are about 35 values on this report that are stored as numbers in a table, and I display the on the report with the Format Property of the textbox set to currency.

What I need to do is blank out any field where the value is 0
- A blank field means that there may be coverage but it isn't listed, while a 0 amount means there is no coverage -

Anyone know the best way to do this?

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Mike,
Can't you use the onformat to check the value of each field? If so:
If Value = 0 then
   value = null
end if

I've never tried it, so I don't know if it will work.

Kevin

dartcoach

Thanks Kevin,

For some reason I couldn't find the OnFormat Event - It seems that reports just don't have the same level of control as forms, but I did put some code into the Report -> Activate event, that checks for a 0 value and then makes the textbox invisible, and that works great.

Thanks again,

Mike

Mike
EchoVue.com

Mike,

The other way wouldn't have worked anyway, I've been playing with it and it doesn't work.

Kevin

dartcoach

Kevin,

No worries at all - sometime, you just need someone to bounce ideas off to get you past the mental blocks.

Mike :D

Mike
EchoVue.com

Mike,
I went back to an old database of mine and found out what I'd done with the same problem.
In the detail section, I created a text box for each field from the table. I.E. mtbl.value1 = table value in currency format.
            myvalue1 = textbox on report
I would then make mtbl.value1 invisible.
in the detail section (or whichever section you're dealing with) I put this in the onformat event:

  If Me.value1 = 0 Then

     Me.myvalue1 = Null
  Else
     Me.myvalue1 = Me.value1
  End If

  Me.myvalue1 = FormatCurrency(Me.myvalue1)



dartcoach