Report error

[matthewR]

What does #Size! mean in a report . Access 2010. I added a field to this report and when I run it I am getting #Size! for the field. It has a little green triangle in the corner of the field in design mode. I am using =NZ([field],0). The other fields that are currently there, have the same set up.

[HansV]

Are you absolutely sure that the field occurs in the Record Source of the report and if so, that its name is spelled correctly? A green triangle in a text box usually indicates that the Control Source is not correct.

[matthewR]

You were right. I copied the report and changed the record source but the field was named something different in the original report. I thought I named all the fields the same but obviously not. Thanks for your help.