Report Field not showing

[dab1477]

I created a report using the report wizard. The query correctly shows all fields. When I run the report one field does not show. All ohter fields show correctly. I've confirmed the field report not showing is correctly bound and that all fields are visible in properties. Any ideas why a field would not show in a report, but does show in the the bound query.

Thanks in advance.

 

[Micron]

When I run the report one field does not show

You're saying the query returns data for that field but that data is not visible in the report (assuming there is not different criteria being used in the 2 instances)? Or does the report field just have no data because there's no data in the query in that field?

The missing field is not a calculated field, and it's visible property when viewed in report design has not been set to No? And the missing field doesn't show up on other report pages because it doesn't fit on the first one?

 

[dab1477]

You're saying the query returns data for that field but that data is not visible in the report (assuming there is not different criteria being used in the 2 instances)?
YES, This is correct. Query returns correct data, but not visible within the report.

Or does the report field just have no data because there's no data in the query in that field?
The query has the correct data. The Report field bound to the query does NOT show data.

The missing field is not a calculated field, and it's visible property when viewed in report design has not been set to No? And the missing field doesn't show up on other report pages because it doesn't fit on the first one?

Correct. Field is NOT calculated. It is bound to the query. Yes, It is visible, meaning the property for the field for Visible = YES. All fields fit on the report page.

 

[Micron]

I should have asked if you can see it in design view. Probably, so unless it has some odd property settings such as being transparent with no border, then I have no other idea as to why. Also, if there's an attached label and it is visible, then it's a stumper for me. I think I'd be creating a new one and binding it to the same field, but maybe set the background color to red just to see if it shows up. I'm not sure if you're saying there's no trace of it, or you can see it but it contains no data.