code to long

I'm creating a button on a form which with combine several fields together.
The code is getting very long and difficult to view by scrolling. How can I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11320-code-to-long.html
break the code to the next line and still work?

Thanks.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Use the underscore character after a space as the line continuation
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11320
character.

Example:
MsgBox _
"Say what?", vbQuestion, _
"This is an example of line continuation code"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"rml" wrote in message
news:792E9335-C283-402C-8F80-300025792C4E@microsoft.com...
> I'm creating a button on a form which with combine several fields
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11320
> together.
> The code is getting very long and difficult to view by scrolling. How can
> I
> break the code to the next line and still work?
>
> Thanks.

Just put a _ wherever you want to break the line.

ex..

this line is _
getting to long

rml wrote:
> I'm creating a button on a form which with combine several fields together.
> The code is getting very long and difficult to view by scrolling. How can I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11320
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11320
> break the code to the next line and still work?
>
> Thanks.