在MS-Access中限制表单或报表上的最大文本框数量的问题 [英] Problem with limit on maximum number of textboxes on a form or report in MS-Access

问题描述

对于在表单上有计算作为控制源的

报表的

报表的明显限制，我能做些什么吗？ ？我有一个查询，将两个表中的所有字段

组合在一起，每个表有大约20个字段。然后，我有一个统计信息

表单，其中包含查询作为源，表单有273个文本框

on，每个都有基于底层查询值的计算。

表格看起来像一个电子表格，第1行到第23行，A到M列。


我检查了文本框中使用的所有公式，它们是

正确。问题是当我打开表单时，我在

中收到一条消息，在Access窗口的下半部分显示计算。对于几个

秒然后填充的文本框将是#error。我试图删除

一些文本框以找出导致错误的文本框，

但我发现它不是特定的文本框公式

是问题，但只是它们的数量（我删除了一半

他们和表格工作。然后我删除了另一半和表格

再次工作。


如果表单上有273个或更多文本框，我该怎么办？


谢谢，

困惑。

Is there anything I can do about the apparent limit on the number of
textboxes that have calculations as their control source on a form or
report in ms-access? I have a query that pulls together all the fields
from two tables, each with about 20 fields. I then have a statistics
form that has the query as its source and the form has 273 textboxes
on, each with a calculation based on the underlying query values. The
form looks like a spreadsheet with row 1 to 23 and columns A to M.

I have checked all the formulas used in the textboxes and they are
correct. The problem is that when I open the form I get a message in
the lower part of Access window that says "calculating" for a couple of
seconds and then the textboxes fill will "#error". I tried deleting
some of the textboxes to find out which ones were causing the error,
but what I found was that it wasn''t particular textboxes formulas that
were the problem, but simply the quantity of them (I deleted half of
them and the form worked. I then deleted the other half and the form
worked again).

What can I do with a form that has 273 or more textboxes on?

Thanks,
Bemused.

推荐答案

< ia ******* ***@btopenworld.com>在消息中写道

新闻：11 ********************* @ z14g2000cwz.googlegro ups.com ...

<ia**********@btopenworld.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

对于包含273个或更多文本框的表单，我该怎么办？

谢谢，
很困惑。

What can I do with a form that has 273 or more textboxes on?

Thanks,
Bemused.

你唯一能做的就是加入Access Morons。发送您的

会员申请表格

ac ***********@hotmail.com


并从着名的Access Morons获得每日的数据库提示，例如

Larry Linson，Tony Toews和其他MVP。

The only thing you can do is join Access Morons. Send your request for a
membership application to

ac***********@hotmail.com

and receive daily moronic database tips from famous Access Morons such as
Larry Linson, Tony Toews, and other MVPs.

Hoo ...为什么你的表单上有273个控件？我的第一个猜测是

你需要规范你的数据

Hoo... why do you have 273 controls on your form? My first guess is
you need to normalize your data

ia ********** @ btopenworld.com 写道：

ia**********@btopenworld.com wrote:

有什么我能做的吗关于在ms-access中在窗体或
报告中计算作为控制源的
文本框数量的明显限制？我有一个查询将两个表中的所有字段组合在一起，每个表有大约20个字段。然后我有一个统计
表单，其中包含查询作为源，表单上有273个文本框，每个文本框都基于底层查询值进行计算。
表单看起来像一个电子表格，第1行到第23行，列A到M.

我检查了文本框中使用的所有公式，它们是正确的。问题是，当我打开表单时，我在Access窗口的下半部分显示一条消息，上面写着计算。几秒钟，然后文本框填充将#error。我尝试删除了一些文本框，以找出导致错误的文本框，但我发现它并不是特定的文本框公式，而是问题，而只是他们的数量（我删除了一半的
他们和形式工作。我然后删除了另一半，表格
再次工作）。

我怎么办有273个或更多文本框的表单？

谢谢，
很困惑。

Is there anything I can do about the apparent limit on the number of
textboxes that have calculations as their control source on a form or
report in ms-access? I have a query that pulls together all the fields
from two tables, each with about 20 fields. I then have a statistics
form that has the query as its source and the form has 273 textboxes
on, each with a calculation based on the underlying query values. The
form looks like a spreadsheet with row 1 to 23 and columns A to M.

I have checked all the formulas used in the textboxes and they are
correct. The problem is that when I open the form I get a message in
the lower part of Access window that says "calculating" for a couple of
seconds and then the textboxes fill will "#error". I tried deleting
some of the textboxes to find out which ones were causing the error,
but what I found was that it wasn''t particular textboxes formulas that
were the problem, but simply the quantity of them (I deleted half of
them and the form worked. I then deleted the other half and the form
worked again).

What can I do with a form that has 273 or more textboxes on?

Thanks,
Bemused.

来自表格的帮助中的规格说明 ;您可以在表单或报表的生命周期内添加的控件数量和

部分为754

如果您正在剪切并粘贴其可能的话，则使用273个文本框

超过了计数。例如，我可以将2个Textbox'，标签

放到空白表单上。然后我会有Text0 / 2和Label1 / 3。如果我把它们两个都切掉了，然后放下一个新的盒子/标签就是Label5 / Text5。


这可能是切割和粘贴谁知道你还有什么？
超过了控制点数。


您可能想要打开一个新表格。然后打开您当前的表格。将当前表单中的所有控件放入新表单中。然后将所有

代码放入新表单中。这会将表单的计数器重置为

，最有可能是较低的计数。

From Specifications in help on forms it states "Number of controls and
sections you can add over the lifetime of the form or report is 754"
With 273 textboxes, if you were cutting and pasting its possible you
exceeded the count. For example, I may drop 2 Textbox''s, with label
onto a blank form. I would then have Text0/2 and Label1/3. If I cut
both of them out and drop a new box/label it is Label5/Text5.

It''s possible that with cutting and pasting and who knows what else you
have exceeded the control count.

You might want to open a new form. Then open your current form. Drop
all controls in your current form into the new form. Then drop all the
code into the new form. This will reset the counter of the form back to
most likely a lower count.

这篇关于在MS-Access中限制表单或报表上的最大文本框数量的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！