Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2005
    Posts
    9

    Question Unanswered: Combining text and having superfluous commas

    Hi,

    In a text box in a form I have the following control source:

    =[Unit Address] & (", "+[Property Address]) & ", " & [Town]

    I have placed the (","+ before Property Address as not everyone has a Unit Address. Even though I have done this I am still getting a comma before Property Address.

    Can someone please help me and tell me what I am doing wrong.

    Many thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Almost there:

    Code:
      
    =([Unit Address]+", ") & [Property Address] & ", " & [Town]
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2005
    Posts
    9
    How infuriating is that ! Thank you so much. Possibly the only variation I didn't try !!

    Once again, thanks.


  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    The thing to remember is:

    NULL + "something" = NULL
    NULL & "something" = "something"

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Well pull my plonker - yuou learn something new every day!
    nice one pootle flump - just goes to show aging vba hackers should rtfm

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by healdem
    Well pull my plonker - yuou learn something new every day!
    nice one pootle flump - just goes to show aging vba hackers should rtfm
    Lol - makes me chortle every time. Perhaps it is the Mancunian in us? I hope you don't mind - I think I've used that on another site and not credited you

    BTW - didn't come from the manual - came from some sloppy and incosistent coding which elicited different results and had me scratching my head for some time. I still maintain you learn 10% from the manual and 90% from your f#*k ups.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Wish I could claim ownership, but first came accross the immortal phrase in 1990 (ish), came from a rich source of vernacular in Stockport. Another gem of the same period were 'does me head in' - espcecially usefull for project reviews.

    Also some came from what was Picadilly Radio (when it was still known as "Picadilly 261") I forget the guys name but he always signed off his program with "thank for your ears", if something appealed to him "groove my truffles" and "well rave on...." - just remembered it was Phil Wood before he defected to the Beeb

    I sometimes deliberately introduce such pearls into meetings with Sceptics and interlopers to this little backwater in the UK.

    After that you can always fall back on the mockney (Mock Cockney rhyming slang) - wonder how many sceptics worked out the ref?
    Last edited by healdem; 10-11-05 at 12:51.

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    [Miles off topic]
    A good review of the classics there - and some excellent ones I've never heard before.
    A couple of other quality phrases -
    Mad as a box of frogs
    He's seen his arse about that one

    A bit of background - in Lancashire and surrounding locales, cock is used as a term of enderment ("Yer alright, cock?"). In said areas, it is not uncommon for a seafood seller (cockles, muscles etc) to tour the pubs. This led to the wonderfully copnstructed (shouted across a crowded pub) - "You got any crabs on yer cock?". Oh, the hilarity that ensued.
    [/Miles off topic]
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •