Visual Basic 6.5 context sensitive/auto-complete wackyness

john john mackey

I am having weird experience with the VBA (MS Access 2007) context sensitive setting for when I try to use it to get a property or method. For example, I have a checkbox in my Access 2007 form. I want to do something simple like use context sensitivity to show the Value property of my checkbox: myChkBox.Value = HOWEVER before I can finish typing "va", the context sensitivity stops and it won't allow me to auto-complete the word. MORE ANNOYING is the side effect when after i type in .Value and press space, the cursor then jumps back to the "e" in value and removes my space. This is the same for other variables and objects: dim bIsCheckSet as Boolean 'sometimes becomes bIsCheckSetas or bIsCheckSet asB the problem: context sensitivity (auto-complete) acting weird and seems to have a "time-out" period that is very short. HELP!

J 0

I experienced this issue a while ago when the form was in Form View not Design View. Doing the coding while in Design View seemed to solve the problem for me.

john john mackey

thanks for the suggestion. it did not correct the whacked-out MS behavior i am seeing with auto-complete. Symptom #3 (of many)

dim bMyBool as Boolean 'becomes dimb (if i wait too long after typing dim)

a short time-out period for auto-complete Symptom #4 (of many)

Me. 'flashes list of properties/methods for Me, but disappears in 0.25 seconds

This is very annoying and counter productive to me - Microsoft products suck like 80% of the time. BTW, is the topic i'm asking about called "auto-complete", "context-sensitive help", "type-ahead" ?? Thanks, Johnny

J 0

I believe the word you're looking for is "Intellisense"

john john mackey

I'm about to rip Microsoft's balls off and shove them down their throat -- except MS doesn't have a pair!:mad: :mad: :mad: This next symptom has me thru the roof!

If (expression) Then
(statements)
Else
(statements)
End If 'WTF - it breaks EndIF into two words End and If and i can't even save it as 1 word

J 0

john john mackey wrote:

'WTF - it breaks EndIF into two words End and If and i can't even save it as 1 word

That's because in VB syntax the end of an if block is End If not EndIf.

Dave Kreskowiak

john john mackey wrote:

This next symptom has me thru the roof!

That's because the End keyword works with other stuff, not just If, like End Sub, End Function, End Select, ...

john john mackey wrote:

WTF - it breaks EndIF into two words End and If and i can't even save it as 1 word

If a single space character is driving you this nuts, you've got other issues to worry about...

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Luc Pattyn

yes, it does, and yet "Endif" (without space) is a reserved keyword and cannot be used as an identifier, e.g. for naming a variable. That is very basic for VB users. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

john john mackey

Yeah, I was wrong on the whole "EndIf" "End" dilema. Sorry. However, my problem was that Intellisense (or auto-complete, context-sensitive help) was all screwy in my VBA code so much so that I couldn't work

1. if i type to slow, the cursor jumps back to the end of the last character, removing spaces and as you can see, trying to define variables would run type and variable name together. :mad:

2. if i try to look up a property for an object, the list would disappear all too quickly. :confused:

Does this call for a re-install of Access 2007?

Luc Pattyn

john john mackey wrote:

Does this call for a re-install of Access 2007?

if it hinders your work continuously, I would certainly give that a try, without hoping too much. I only ever did one Access+VBA project, more than 10 years ago; it was a simple application, about 3 forms, simple logic; I stumbled on dozens of bugs, each requiring newer versions, fixes, workarounds. I got it to work after lots of trouble, so I try not to do another one any time soon. Good luck though. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Getting an article published on CodeProject now is hard and not sufficiently rewarded.

john john mackey

I still want to feed MS their own body parts! :mad: I guess I'm gonna reinstall. my latest complaint about my Access 2007, VBA is that when i (mistakenly) issued a search for a word while there were no code windows open, the VBA editor got frozen and was unresponsive to Cancel, any menu commands, and the Hour Glass icon just remained persistent. So reinstall is what I think i will try next. I don't know what updates hosed over my Access, but now i'm just pissed. the biggest annoyance/problem is: defining variables, such as

dim bMyVar as Boolean

but having it appear as

dimbMyVar

dimb MyVar asBo

dim
MyVarasBo