报告中的备注字段截断为255个字符 [英] memo field in report truncating at 255 characters

问题描述

我在报告中有一个备注字段，截断为255个字符。我尝试过以下几乎没有成功：1。成长/收缩选项是肯定的。 2.分组依据改为第一次。 3.分组依据改为最后 4.取出备忘录字段，保存查询，并重新插入备忘录字段。似乎没有什么能解决这个问题。请帮忙！非常感谢任何建议。

I have a memo field in a report that is truncating at 255 characters. I''ve tried the following w/no success: 1. Grow/Shrink option is yes. 2. "Group By" changed to "first". 3. "Group by" changed to "last" 4. took out memo field, saved query, and reinserted memo field. nothing seems to be fixing this bug. Please help! any suggestions are greatly appreciated.

推荐答案

报告中的备注字段截断为255个字符。我尝试过以下几乎没有成功：1。成长/收缩选项是肯定的。 2.分组依据改为第一次。 3.分组依据改为最后 4.取出备忘录字段，保存查询，并重新插入备忘录字段。似乎没有什么能解决这个问题。请帮忙！任何建议都非常感谢。

I have a memo field in a report that is truncating at 255 characters. I''ve tried the following w/no success: 1. Grow/Shrink option is yes. 2. "Group By" changed to "first". 3. "Group by" changed to "last" 4. took out memo field, saved query, and reinserted memo field. nothing seems to be fixing this bug. Please help! any suggestions are greatly appreciated.

备注字段在表格中是否显示正确？如果是这样，可能是查询本身就是问题的原因。你介意发帖吗？

Does the memo field display correcty in your table? If so, it may be the query itself that is the cause of the problem. Would you mind posting the query?

对你有好处JLC（我真的不能每次都写jenkinsloveschicken :)）。

它''总是很高兴看到初级会员帮助解答。在这种情况下，我怀疑OP正在尝试在报告中显示该项目时遇到问题。报告没有备忘录控件。 IE浏览器。他们必须尝试使用​​TextBox显示备注字段 - 最大长度为255个字符。

您可能也在查询的右侧 - 我不确定也支持大于255个字符的任何内容。

Good for you JLC (I really can''t write jenkinsloveschicken every time can I :)).
It''s always good to see Junior Members helping with answers. In this case I suspect the OP is having the problem as they are trying to display the item in a report. Reports don''t have Memo controls. IE. They must be trying to display a Memo field using a TextBox - for which the maximum length is 255 characters.
You may also be on the right lines with the query though - I''m not sure that would support anything greater than 255 characters either.

我想我终于明白了。我确实有一个备忘录字段（不是文本字段）。备注字段似乎显示当前信息中的所有字符，但不适用于从excel导入访问的旧数据。只要我显示当前的信息，它就不再是一个大问题了。非常感谢你的建议和提示。

-Jenn

I think I finally figured it out. I did have a memo field (not text field). The memo field seems to display all characters on current information, but was not working for older data that was imported into access from excel. As long as my current info is displaying, it''s not a big problem anymore. thanks so much for the advice & tips.
-Jenn

对你有好处JLC（我真的不能写每一个jenkinsloveschicken时间可以:)）。

看到初级会员帮助解答总是好的。在这种情况下，我怀疑OP正在尝试在报告中显示该项目时遇到问题。报告没有备忘录控件。 IE浏览器。他们必须尝试使用​​TextBox显示备注字段 - 最大长度为255个字符。

您可能也在查询的右侧 - 我不确定支持大于255个字符的任何内容。

Good for you JLC (I really can''t write jenkinsloveschicken every time can I :)).
It''s always good to see Junior Members helping with answers. In this case I suspect the OP is having the problem as they are trying to display the item in a report. Reports don''t have Memo controls. IE. They must be trying to display a Memo field using a TextBox - for which the maximum length is 255 characters.
You may also be on the right lines with the query though - I''m not sure that would support anything greater than 255 characters either.

这篇关于报告中的备注字段截断为255个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！