Keyboard shortcut...

[Guest]

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!

 

[Duane Hookom]

Where are you viewing this? If a query design, press Alt+V then Q.

 

[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;")

 

[Guest]

(Alt+V then Q) is helpful when I'm in a query...

Thanks!

 

[Guest]

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

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

Thanks!