Consulting

Results 1 to 5 of 5

Thread: Access VBE

  1. #1
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location

    Access VBE

    I have noticed some strange behaviour in the Access VBE. Heck, I have noticed strange behaviours in all VBEs, but this is different ...

    In all VBEs (I think) when a statement is flagged as bogus (in red) and it contains one or more continuation characters ( "_" ), they seem to disappear when you click on the OK button to make corrections. This has always bothered me as there is no legitimate reason for the VBE to do this. The Access VBE seems to take this a step further. It deletes any continuation characters; but it also deletes any plus signs ( "+" ) -- but leaves ampersands ( "&" ) alone.

    Any idea why?
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  2. #2
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    I can't reproduce this at all - in Access or any other VBE (using 2003)
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  3. #3
    VBAX Mentor Brandtrock's Avatar
    Joined
    Jun 2004
    Location
    Titonka, IA
    Posts
    399
    Location
    I couldn't either. Using 2000.
    Brandtrock




  4. #4
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by TonyJollans
    I can't reproduce this at all - in Access or any other VBE (using 2003)
    Quote Originally Posted by Brandtrock
    I couldn't either. Using 2000.
    what can I say? Happens all the time to me.

    I seem to remember that I asked about the first part (disappearing continuation characters previously) and someone indicated that the VBE did misbehave in that manner.

    I will document the exact circumstances for a few days and post back
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  5. #5
    Administrator
    VP-Knowledge Base
    VBAX Guru MOS MASTER's Avatar
    Joined
    Apr 2005
    Location
    Breda, The Netherlands
    Posts
    3,281
    Location
    Do that Mark I'd like to test it as well!
    _________
    Groetjes,

    Joost Verdaasdonk
    M.O.S. Master

    Mark your thread solved, when it has been, by hitting the Thread Tools dropdown at the top of the thread.
    (I don't answer questions asked through E-mail or PM's)

Posting Permissions

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