如何在Access中向表单显示备注字段 [英] How do I display a memo field to a Form in Access

问题描述

我已经查看了先前询问的与此相关的问题，但未能找到解决方案.我有一个带有备注字段的表，该备注字段称为"Comments"，并且我试图在表单中显示该字段的所有历史记录.在控件源的文本框属性中，我有以下内容:

I have looked at the previous questions asked relating to this but haven't been able to find a solution. I have a table with a memo field called "Comments", and I am trying to display all the history of the field in the form. In the text box properties in the control source I have this:

ColumnHistory([位置]，[注释]，[JobID =]& [JobID])(位置是表名，注释是备注字段，而JobID是主键标识符).我在该字段中收到一个#Name错误，但我不明白为什么.我对数据库非常缺乏经验，但是正在尝试学习和做这个项目.感谢您的帮助

ColumnHistory([Positions], [Comments], [JobID=]&[JobID]) (Positions is the table name, Comments is the memo field, and JobID is the primary key indentifier). I get a #Name error in the field and I dont understand why. I am very inexperienced with databases but am trying to learn and do this project. Any Help is appreciated Thank you

推荐答案

首先，请确保注释"字段的AppendOnly属性设置为 True ，否则将不起作用.

First of all, make sure the Comments field's AppendOnly property is set to True or this will not work.

接下来，文本框控件中的代码应显示为:

Next, the code in the text box control should read:

= Application.ColumnHistory("Positions", "Comments", "JobID=" & Me.JobID & "")

如果您的变量，对象或控件中的任何内容与所述内容不同，则可能需要进行一些调整.

If any of your variables, objects or controls is different than stated, you might need to tweak that a bit.

我看到您是新来的人，因此请确保您确认这是否对您有用，以便将来有类似问题的访客都知道答案是否可行.

I see you're new here, so please make sure that you confirm whether or not this worked for you so future visitors with similar questions will know if the answer is viable.

这篇关于如何在Access中向表单显示备注字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！