want blank when no zip code

[leahf via AccessMonster.com]

A customer can have either a list of students, or labels for the students.
Both the labels and the list of students are reports that come from the same
query.

In order that the zip code not show 0 when there is no zip code listed, I
have a function for the zip code which checks if the zip is < 5 characters.
If it is less than 5 characters, it displays blank.

For whatever reason, it works in the labels but I keep getting an error when
I use it in the list of students report.

Same query, same function. Any ideas why I am getting #ERROR in the report?

THanks.
Leah

 

[leahf via AccessMonster.com]

Just to clarify, the zip code is a string.

A customer can have either a list of students, or labels for the students.
Both the labels and the list of students are reports that come from the same
query.

In order that the zip code not show 0 when there is no zip code listed, I
have a function for the zip code which checks if the zip is < 5 characters.
If it is less than 5 characters, it displays blank.

For whatever reason, it works in the labels but I keep getting an error when
I use it in the list of students report.

Same query, same function. Any ideas why I am getting #ERROR in the report?

THanks.
Leah

 

[leahf via AccessMonster.com]

After working on this for at least an hour, redefining the text box etc., I
tried it again and it worked.

I won't even BEGIN to figure out what happened before. I even had someone
else check it out before and she couldn't figure it out...

Thanks to anyone who tried to check out the problem.
Leah

Just to clarify, the zip code is a string.

A customer can have either a list of students, or labels for the students.
Both the labels and the list of students are reports that come from the same

[quoted text clipped - 11 lines]

THanks.
Leah