Can't find underlying expression for field in report

P

PZStraube

Hello,
I'm a novice with expressions in report. I created the following for one
field that is not always in the underlying query so that the report will run
even when that field is missing.

Sub Check4Errors
On Error Goto SkipField
[C]
SkipField:
End Sub

Much to my surprise, it actually worked. However, the box changed to
showing "Unbound" instead of the variable name (C) and now I can't figure out
how to view and edit the expression I built. The Control Source shows as
blank. The expression works fine, though.
If someone could tell me where to find how to view and edit this expression,
I would be very appreciative. I hope this is a basic question.
Thanks so much!
 
P

PZ Straube

Me again.
Well, I screwed up. What I thought worked actually doesn't. While it
surpresses error messages when a field is missing, it doesn't print the field
when it is there. Ah, the joys of being a novice.

So, please let me change my post to this:

How do I have a field avialable in a report that will print the data when
that field is in the underlying query AND will not generate en error message
when the field is not in the underlying query.
Thank and sorry to have wasted anyone's time.
 
F

Fons Ponsioen

PZ, I do not quite understand what you are refering to.
Do you mean that when a field is null in a query or what
can you post some example?
Fons
-----Original Message-----
Me again.
Well, I screwed up. What I thought worked actually doesn't. While it
surpresses error messages when a field is missing, it doesn't print the field
when it is there. Ah, the joys of being a novice.

So, please let me change my post to this:

How do I have a field avialable in a report that will print the data when
that field is in the underlying query AND will not generate en error message
when the field is not in the underlying query.
Thank and sorry to have wasted anyone's time.


PZStraube said:
Hello,
I'm a novice with expressions in report. I created the following for one
field that is not always in the underlying query so that the report will run
even when that field is missing.

Sub Check4Errors
On Error Goto SkipField
[C]
SkipField:
End Sub

Much to my surprise, it actually worked. However, the box changed to
showing "Unbound" instead of the variable name (C) and now I can't figure out
how to view and edit the expression I built. The Control Source shows as
blank. The expression works fine, though.
If someone could tell me where to find how to view and edit this expression,
I would be very appreciative. I hope this is a basic question.
Thanks so much!
Click to expand...
.
Click to expand...
 
Top