Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    L.A., California
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Words Capitalizing (xp)

    Hello,

    This is a wierd quirk, which I've also noticed in Access vba.

    Suddenly, all instances of the Rows property in my vba code has been replaced by ROWS. This happened after I copied some code from another Excel project which happened to refer to ROWS. If I globally replace "ROWS" with "Rows", it works, but when I move my cursor off a line containing the "Rows" word, they all change back to "ROWS". I've tried globally changing them to something else, say "Rowsx", which works fine, but when I then change them back to "Rows", they get capitalized again.

    This is not a critical problem, as everything is working ok. On the other hand, this is quite curious. Anybody have any ideas? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Words Capitalizing (xp)

    Have you DIMed a variable named ROWS somewhere in your code?
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    L.A., California
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Words Capitalizing (xp)

    That's what I thought of, too. But, I only have 1 module, and I've searched it extensively. No ROWS defined. I do have a dialog sheet with a listbox and a couple of buttons, but the only code they refer to is in my module.

    This is baffling. <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Words Capitalizing (xp)

    I have noticed this too. VBA seems to keep some kind of internal list or table of how names are spelled; even if the last vestige of this name has been purged from your code, the name is not deleted from the list. It's more an annoyance than a real problem, and I don't know of a solution that works consistently.

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    L.A., California
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Words Capitalizing (xp)

    Guess I'm stuck with it, then. I tried exporting and removing the module, then editing the exported file in Notepad to put ROWS in the proper case, then saving the file, then importing the module again. No luck. Oh well......

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Words Capitalizing (xp)

    I had this a while back, then it magically cured itself. FWIW, try the old "save file as HTML, re-save as XLS" trick.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Words Capitalizing (xp)

    Have you tried DIMing a variable defined the way you want it to appear, and then deleting the DIM statement?
    Legare Coleman

  8. #8
    Star Lounger
    Join Date
    Jan 2001
    Location
    L.A., California
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Words Capitalizing (xp)

    That did the trick, thank you. Amazing that such a simple solution solved the problem. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Words Capitalizing (xp)

    I'm happy that this worked for you. Sadly, it doesn't always do the trick in Access (at least, for me.)

Posting Permissions

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