Nz returning #size!

[ShostyFan]

I have as a txt box control source:
=Nz(IinventoryCount].[Form]![MaxDateCount],0)



When there is a date in the MaxDateCount the data is viewed as desired, but when the field is empty I get #size!

Not sure how to handle this, but I did try:
=Nz(IinventoryCount].[Form]![MaxDateCount],NULL)
=Nz(IinventoryCount].[Form]![MaxDateCount]," ")

All efforts have returned #size!

Thanks.

[AccessPower]

=IIf(Len(IinventoryCount].[Form]![MaxDateCount]) > 0, "True", "False")))

Untested. might be what you're looking for.

[pbaldy]

Are you running into this?

http://access.mvps.org/access/forms/frm0022.htm

[ShostyFan]

I looked into the link Paul sent and it didn't seem to be same issue I am experiencing.
I decided to approach the problem with a query join instead of a vba reference.
thanks for the ideas.

[pbaldy]

Glad you got it sorted. It sounded like you were getting the error when the subform didn't have any records. The method in the link would have handled that.

[Micron]

have never seen this one, but I wonder if =Nz(Eval(IinventoryCount].[Form]![MaxDateCount]),0) would have done it.