名称？报告中的错误 - 仅限打印视图（访问2010） [英] Name? error in Report - print view only (access 2010)

问题描述

嗨 - 我的报告基于查询。我的报告中的第一个字段是来自查询的字段，该字段是2个不同字段（公司和州）的组合 - 在查询中看起来很棒，没有问题。我运行我的报告，它是完美的，按预期拉入现场 - 直到我导出到PDF或进行打印预览，此时它显示名称？。在那个领域。我的报告为每个公司列出了此字段，报告的其余部分在两个视图中都完美显示;它只是第一个出现错误的记录。


有什么想法吗？我确定我在某个地方做错了什么，但还是找不到什么 - 尽管用Google搜索并搜索到处都可以思考。


谢谢你help！

Hi - I have a report that''s based off a query. The first field in my report is a field from the query that was a combination of 2 different fields (company & state) - looks great in the query, no problems. I run my report and it''s perfect, pulls in the field just as expected - until I either export to PDF or do a Print Preview, at which point it displays "Name?" in that field. My report has this field listed for each company, and the rest of the report displays perfectly in either view; it''s just the very first record that gets that error.

Any ideas? I''m sure I''m doing something wrong somewhere, but haven''t been able to identify what - despite Googling it and searching everywhere I can think.

Thanks for your help!

推荐答案

请提供SELECT行的相关部分（来自查询的SQL），并描述如何定义报表控件。我认为它是一个TextBox。是否有任何代码在报表的Open事件过程中运行？

Please provide the relevant part of the SELECT line (from the SQL of your query), as well as describe how the control on your report is defined. I assume it''s a TextBox. Does any code run in your report''s Open event procedure?

这里是查询中的Select语句：


[Organization_desc ]。[组织]& ， &安培; [Organization_desc]。[State] AS Org_State


表单'的记录源是这个查询，这个字段的控制源是Org_State（我可以从一个drop-中选择）菜单）。

是的，它是一个文本框。


我还应该提到我的查询/报告中有一个辅助字段''是一个字段的组合（全名，它结合了名字和姓氏），并且该字段完全没有问题。

Here''s the Select statement from the query:

[Organization_desc].[Organization] & ", " & [Organization_desc].[State] AS Org_State

The form''s record source is this query, and the Control Source for this field is Org_State (which I can pick from a drop-down menu).
And yes, it''s a Text Box.

I should also mention that I have a secondary field in my query/report that''s a combination of fields (full name which combines first and last name), and there''s no trouble at all with that field.

报告中没有代码''任何地方的模块？


我必须承认，到目前为止我看到的内容并没有什么不妥。当然，它会使该字段不可更新，但为什么它会在您描述的任何情况下都无法显示我不知道 - 除非代码干扰。

And no code in the report''s module anywhere?

I must admit I see nothing untoward with what you''ve shown so far. It would make that field non-updatable, certainly, but why it would fail to display in any circumstances you''ve described I don''t know - unless the code is interfering.

这篇关于名称？报告中的错误 - 仅限打印视图（访问2010）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！