line continuation - a way to increase the limitation?

[Mark]

Access allows a limit of 25 line continuations.

Is there a setting to increase the limitation? Or a nifty work around?

When your building sql in code its way less messy to layout one field per
line.

Thanks, Mark

 

[Wayne Morgan]

The only work around I can think of would be to break down your string into
smaller portions then concatenate them together.

Example:
strSQL = "SELECT * FROM tblMyTable"
strWHERE = "WHERE tblMyTable.Field1 = 3"
strSQL = strSQL & " " & strWHERE