Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spaces in field names

    I am having a problem with a script I'm writing for a custom outlook form. I posted the problem <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=out&Number=39266&page=0&vie w=expanded&sb=5>here</A> on the Outlook board - any help is appreciated.

    Thanks,

    Mary

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spaces in field names

    Mary,

    I suspect you're running up against the MS convention of including the quotes in any value that includes spaces. So, you just need to stip out the quotes:

    <pre>If InStr(VarName, " ") <> 0 Then 'Name has spaces
    VarName = Mid$(VarName, 2, Len(VarName) - 2)
    End If
    </pre>

    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Lounger
    Join Date
    Jan 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spaces in field names

    Thanks Kevin, I'll give that a try. Although I have to admit that I've renamed most of my fields already. :-)

    Mary

Posting Permissions

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