As i am not a programmer i do not know if there is a limit to the length of a
module or ist it not good practise to have it too long/big ??
--
Les

Yes there is a limit to the size of a module, but I do not remember what it
is. That being said it is good practice to not make your modules too big. Far
too difficult to debug. Each module should do it's own set of tasks. For
example perhaps you will want to put all of your sorting routines in one
module and all of your printing routines in another. That makes debugging
much easier. You can change the names of your module by changing the name in
the properties window (F4 in the VBE).
--
HTH...

Jim Thomlinson


"Les" wrote:

As i am not a programmer i do not know if there is a limit to the length of a
module or ist it not good practise to have it too long/big ??
--
Les

Thank you very much Jim, much appreciated...
--
Les


"Jim Thomlinson" wrote:

Yes there is a limit to the size of a module, but I do not remember what it
is. That being said it is good practice to not make your modules too big. Far
too difficult to debug. Each module should do it's own set of tasks. For
example perhaps you will want to put all of your sorting routines in one
module and all of your printing routines in another. That makes debugging
much easier. You can change the names of your module by changing the name in
the properties window (F4 in the VBE).
--
HTH...

Jim Thomlinson


"Les" wrote:

As i am not a programmer i do not know if there is a limit to the length of a
module or ist it not good practise to have it too long/big ??
--
Les

its about 64k.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jim Thomlinson" wrote in message
...
Yes there is a limit to the size of a module, but I do not remember what
it
is. That being said it is good practice to not make your modules too big.
Far
too difficult to debug. Each module should do it's own set of tasks. For
example perhaps you will want to put all of your sorting routines in one
module and all of your printing routines in another. That makes debugging
much easier. You can change the names of your module by changing the name
in
the properties window (F4 in the VBE).
--
HTH...

Jim Thomlinson


"Les" wrote:

As i am not a programmer i do not know if there is a limit to the length
of a
module or ist it not good practise to have it too long/big ??
--
Les

Thanks Bob
--
Les


"Bob Phillips" wrote:

its about 64k.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jim Thomlinson" wrote in message
...
Yes there is a limit to the size of a module, but I do not remember what
it
is. That being said it is good practice to not make your modules too big.
Far
too difficult to debug. Each module should do it's own set of tasks. For
example perhaps you will want to put all of your sorting routines in one
module and all of your printing routines in another. That makes debugging
much easier. You can change the names of your module by changing the name
in
the properties window (F4 in the VBE).
--
HTH...

Jim Thomlinson


"Les" wrote:

As i am not a programmer i do not know if there is a limit to the length
of a
module or ist it not good practise to have it too long/big ??
--
Les