line continuation - a way to increase the limitation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top