Access VBA子例程的最大大小是多少? [英] What is the max size of an Access VBA Subroutine?

问题描述

Access 2003 VBA子例程的最大大小为64K吗?

Is 64K the max size of an Access 2003 VBA subroutine?

推荐答案

旧版本的VBA的已编译模块的最大大小为64K.

VB6在单个过程/函数/子例程中最多有64K行代码

在一个模块中，它的最大标识符数也限制为64k.

这些限制中的某些限制可能在最新版本的VBA中不再存在，但是我无法想到Microsoft会费心投入任何资源以消除对子例程大小的64k限制的任何原因.

如果您有一个子例程，该子例程的大小接近于该大小，则实际上应该将其拆分.

Older versions of VBA had a 64K maximum size of a compiled module.

VB6 had a limit of 64K lines of code in a single procedure / function / subroutine

It also had a limit of 64k maximum identifiers in a module.

It''s possible that some of those limits may no longer exist in the latest versions of VBA, but I can''t conceive of any reason why Microsoft would bother to invest any resources in removing a 64k limit on the size of a subroutine.

If you have a single subroutine that''s anywhere near that size, it really should be split up.

这篇关于Access VBA子例程的最大大小是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！