Trap missing query field in a bound object to make filed not visible

[JBLoafer]

I have a form that I'm trying to make universal so I don't have to keep redesigning it. Typically it shows the 7 days of a week for a series of events that take place every year. However the days change from year to year. If there is a missing field in the underlying the query, Access displays "Name" in the bound text box. I would like to trap this message and instead make the box invisible. Seems like I need some On Open code for the form but how do I intercept the error(s) that access detects? As there are presently 12 events and therefore 84 members of the grid, a bit of code shrinking might be useful too.
This is for aesthetics as well as letting the user focus on the only allowed days.

[June7]

Is a CROSSTAB query involved?

Making the box 'invisible' will not compress the space. There will still be a blank spot where the box sits. Can try to not show the error, never tried:

=IIf(IsError([fieldname]),Null,[fieldname])

[JBLoafer]

Is a CROSSTAB query involved?

Making the box 'invisible' will not compress the space. There will still be a blank spot where the box sits. Can try to not show the error, never tried:

=IIf(IsError([fieldname]),Null,[fieldname])

June7
Thanks a deal for a quick response. I've tried your suggested code but using an unbound text box and it does work.
Re your concern about compressing the space, I really want to have all the real responses in their proper place in the grid. All I need to do now is to set the text box background to the form background so it is invisible to the user. I'll try doing that using conditional format, as I have done that on other forms.
so with a bit of luck, job done, and thanks very much for the tip on recognising the right word to trap the deliberately missing query field.