line continuation - a way to increase the limitation?

M

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
 
W

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
 
Top