Keyboard shortcut...

H

Heidelberg

Is there a keyboard shortcut that shows a complete line of text? For
example: When checking a SELECT, FROM, ORDER BY text that is too long to view
can you use a keyboard shortcut to view the total phrase? I know that Excel
has one, does Access have one?

Thanks!
 
J

John Nurick

Do you mean Shift+F2?

If you're writing VBA code, use the line continuation symbol " _" so you
can wrap long statements onto multiple lines, e.g.

Set MyRecordSetWithALongName = CurrentDB.OpenRecordset( _
"SELECT Field1, Field2, Field3, Field4, Field5, Field7 " _
& "FROM ATable ORDER BY Field6, Field1;")
 
H

Heidelberg

(Shift + F2) is what I was looking for...

However, thanks for the bonus... The "-" will be of help when I am in VBA...

Thanks!
 
Top