error for date field in IIF control source 1

[jamaarneen]

Hi

I entered the following as control source for a textbox:

=IIf([IsSold]<>0;[pro_SaleDate];'X')

If 'IsSold' = 0, I get X, and that's good.
but the problem is, that if 'IsSold' <> 0, I am getting an error instead of a date.
I really don't know why. Can somebody please tell me?

note: i have tried to put a textbox bounded direct to the field 'pro_SaleDate', and it worked good.

Thanks, Ja

 

[Remou]

Is the control called pro_SaleDate? If so, rename it and see if that works.

 

[jamaarneen]

You are GREAT Remou,

I did your suggestion and it worked fantastic.

[Only, I had to re-fix what access does for me. because when I added "txt_" to the textbox name, access was 'smart' and added the same to the "field name" in the control source expression.]

Thanks a lot, Ja