crystal reports question

[Brad]

I know this is the VB group, but maybe somebody knows the answer to this.
On a Crystal Report that I am using as a form, it pulls in various dated
information. In the fields where there are dates I have boxes drawn. What
I need is if there is a date in the field, I want this box to be blacked-out
or "X"ed. How is this done?

I know about the small "x" or small "o" wingding, but how do I say in a
crystal report that if field1 is not null, then convert box1 to wingding
small x?

Thanks for any information.

Brad

 

[Mark Jones]

Create a new formula field.
Make sure you are using basic syntax to keep this post slightly on topic.

If ISDATE({MyDate}) Then
formula = "o"
Else
formula = "x"
End If

Now format it to wingdings or whatever and let it rip.

 

[Brad]

Mark,

Thank you for your help. In the code that you gave me I have created the
following:

If ISDATE({SchedLic.AGD1}) then
formula = "x"
else
formula = "o"
end if

When I check this formula, I keep getting the error "A String is Required
Here" and it highlights the field - {SchedLic.AGD1}.

What might I be missing here?

Brad

 

[Brad]

Mark,

This is how I resolved the problem:

If {SchedLic.AGD1}<>cdate(0, 0, 0) then
formula="x"
else
formula="o"
end if

But again, thank you for your help for you gave me a starting point.

Brad