date conversion & conditional printing

  • Thread starter Thread starter KStringer
  • Start date Start date
K

KStringer

Ok, I have a date field. I only want that date field to print out of there
is something in the corresponding action field.

I set up a 'iif' statement in the data field (like I do on tons of other
things) and the conditions are working just fine, but the date shows up as
'#Error" - I tried doing the cstr on the date and it shows up as 'Error 0'

Should I be using a different converter or something?

Please help.

Thanks.
 
Ok, I have a date field. I only want that date field to print out of there
is something in the corresponding action field.

I set up a 'iif' statement in the data field (like I do on tons of other
things) and the conditions are working just fine, but the date shows up as
'#Error" - I tried doing the cstr on the date and it shows up as 'Error 0'
Click to expand...


First, make sure the text box is named something other than
the name of date field.

If that's not it, pleas provide more details.
 
Bingo!

You da man!

I had started with the date field, then decided to print based on the
condition. It didn't like that. I changed it to a text box and good to go!

Thanks!
 
Back
Top