Wrapping Declaration Line

[Dave]

Several postings warn of the line wraps in the supplied code, and the
question of how to wrap code lines has been answered elsewhere.
Wrapping works within the body of my code, but causes a compile error
when I attempt it within a Private Declare Function line. Are there
limitations on where lines can be wrapped?

 

[Dave]

Several postings warn of the line wraps in the supplied code, and the
question of how to wrap code lines has been answered elsewhere.
Wrapping works within the body of my code, but causes a compile error
when I attempt it within a Private Declare Function line. Are there
limitations on where lines can be wrapped?

If there are limitations, the question can still stand. Otherwise,
please ignore my carelessness as I discovered the offending line was
part of a preceding function that was supposed to be all commented out.

 

[John W. Vinson]

Several postings warn of the line wraps in the supplied code, and the
question of how to wrap code lines has been answered elsewhere.
Wrapping works within the body of my code, but causes a compile error
when I attempt it within a Private Declare Function line. Are there
limitations on where lines can be wrapped?

You can use the _ continuation character to wrap lines (within limits, I think
you can only have ten or so continuation lines) in the VBA window. If a line
ends with a blank followed by an underscore Access will treat the next line as
a continuation.

Otherwise, each logical statement - Private Function XYZ(argument, argument,
argument, argument, argument) for example - must be on one line.