Re: How to continue a line -- space_underscore

Hi, Crystal.

Please don't hijack threads by changing the subject line. While many
newsreaders will keep posts in the thread intact regardless of the subject,
some newsreaders do not. In those newsreaders, once the subject is changed,
it starts a new thread in the middle of a conversation, often leaving a
confusing context for the reader to try to sort out the trail of.

So by changing the subject, even to correct a spelling mistake, one risks
losing one's audience. One may also give the impression that this part of
the conversation shouldn't be handled within the original conversation, as
in "Let's take this fight outside so the others don't get involved in our
disagreement." And by commandeering the thread, one also risks offending
the original poster.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"strive4peace" <strive4peace2006@xxxxxxxxx> wrote in message
news:e5bnmQ9PHHA.4492@xxxxxxxxxxxxxxxxxxxxxxx
Hi Nancy,

if you are breaking a string, you will need & ... but if you are not, then
you won't.

Here are some examples:

'~~~~~~~~~~~~
strSQL = "SELECT email " _
& " FROM [YourTablename] " _
& " WHERE conditions " _
& " ORDER BY somefieldname;"
'~~~~~~~~~~~~

& is used because the SQL statement is one string

'~~~~~~~~~~~~
Msgbox "This is a message" _
, _
, "Here is the title"
'~~~~~~~~~~~~

& is NOT used here because the different lines are used just to make the
parameters easier to follow and there is nothing that needs to be
concatenated (combined)

... it just depends on what the statement is and where you break it

'~~~~~~~~~~~~
Msgbox "This line one of a message" _
& vbCrLf & " and line 2 of the message" _
& " because vbCrLf means to add a line break" _
, _
, "Here is the title"
'~~~~~~~~~~~~

when you do break lines, remember to add the necessary spaces! I like to
put & at the beginning of a line if it needs it as well as start each
literal string with a space if it is a continuation


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Nancy wrote:
Thank you. Yes that is what I meant. I realized it wasn't very
detailed, so I did another post. Actually, the other response said & _
(amersand, space, underscore)
I guess I will try bother.



.

Relevant Pages

  • Re: How to continue a line -- space_underscore
    ... MVP Access ... See http://www.QBuilt.com for all your database needs. ... Many search engines differentiate newsgroup posts by the subject line, so your "arguments that you took out back" will be filtered out much of the time. ... The majority of posts to UseNet use these two newsreaders, ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to continue a line -- space_underscore
    ... UtterAccess isn't UseNet. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... Many search engines differentiate newsgroup posts by the subject line, ... Those who are using the two most popular newsreaders may see the problem. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Guelph to Fergus in less than 1000 calories
    ... I use different newsreaders for different things. ... Thunderbird lets me ... If you would just fucking listen to those telling you how ... cross posts can be in a thread before it kills them too. ...
    (rec.bicycles.misc)
  • Re: Why doesnt 2003 version of Word recognize spellchecking from
    ... Microsoft MVP ... >> with Usenet or newsreaders or ... >> The Web interface is very much a work in progress. ... Authentication required for posts to cut down on spam and abusive ...
    (microsoft.public.word.docmanagement)
  • Re: How to continue a line -- space_underscore
    ... If, on the other hand, you think your posts include information that may be of benefit to others, then please reconsider using best practices for UseNet's medium, not for UtterAccess's medium. ... See http://www.QBuilt.com for all your database needs. ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... The majority of posts to UseNet use these two newsreaders, ...
    (microsoft.public.access.modulesdaovba)
Loading