文本框格式 [英] Textbox format
问题描述
亲爱的,
表格,我有一个子表格,显示表格中的一些信息。
在这个子表格中,我有3个字段,例如field1,field2,field3,它们实际上是表格中三个字段的代表。
子表单中的
,我想要一个字段这显示了field1 / field2 / field3
所以我创建了一个新的未绑定字段,在记录源中,我写道:= field1 +" /" + field2 +" /" + field3
它正在工作,但它的动作非常慢。所有其他字段都在眨眼间显示,但这个字段大约需要0.5-1秒才能显示。
还有另一种方法可以更快地完成此操作吗?
一种方法是编写一个包含Field1,Field 2和Field3的查询,然后是第四个表达式字段将新来源保存为一个表达式,它等于你对Unbound控件的来源。
这应该显示得更快。
希望这有助于
Leon
我的英语不太好。你能解释一下吗??????我没有得到图片。
抱歉不明白。
从你用来填充Subform的表中,你想要的写一个新查询。
包括这个子表单所需的所有字段。
也写一个新的未绑定字段。字段(这是一个表达式)
称之为myfield123
在这个新字段中放置您在子表单上的未绑定控件的源
[Field1] +" /" + [Field2] +" /" + [Field3]
保存这个新查询并将子表单的记录源更改为您刚刚编写的查询。
也更改了包含表达式的字段名称的控件名称。
这将使用您一直使用的记录源替换当前记录源,并添加新字段myfield123 ; (或者你选择给它命名的任何东西),它将显示你的示例字段的内容
希望这会有所帮助
Leon
Dear all,
in a form, I have a subform which shows some information from a table.
in this subform, I have 3 fields, say for example, field1, field2, field3, which are in fact representatives of three fields in the table itself.
in the subform, I want to have a field that shows field1/field2/field3
So I created a new unbound field, and in the record source, I wrote: =field1 + "/" + field2 + "/" + field3
It is working, but it acts so slow. all the other fields are shown in the blink of an eye, but this field takes about 0.5 - 1 second to appear.
is there another way to do this faster?
Hi,
one way would be to write a query having the Field1, Field 2 and Field3, then a fourth expression field which holds the new source as an expression which would equal the source you have for the Unbound control.
This should display a lot faster.
Hope this Helps
Leon
I am not so good in English. Can you please explain a little bit more?????? I don''t get the image.
Apologies for being ambiguous.
From the Table you are using to populate the Subform, you want to write a new query.
Include all of the fields you require for this subform.
also, write a new "unbound" field (this is an expression)
call it something like myfield123
in this new field you place the source for the unbound control you have on the subform
[Field1] + "/" + [Field2] + "/" + [Field3]
save this new query and change the recordsource of the subform to the query you have just written.
also change the name of the control to the name of the field containing the expression.
This will replace the current recordsource with the recordsource you have been using, with the addition of the new field "myfield123" (or whatever you choose to name it) which will show the Contents of your example fields
Hope this helps
Leon
这篇关于文本框格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!