getting #size error in print preview

[barlee]

I have a daily report of appointments that I want to print regardless if there are appointments or not.

I set the control source on the [Appointment Date] field to say:
IIf([Appointment Date] isNull,"No New Appointments",[Appointment Date])

This displays great in Report View, but in Print Preview I get a #size! error in that field.

What the heck! How do I solve this?

 

[barlee]

ok, this is what I finally came up with:

=IIf(IsError([Appointment Date]),"No New Appointments",Nz([Appointment Date],"No New Appointments"))

seems to be working.....fingers crossed...