Here's something I've never seen, heard of, or imagined before!

I recently created a "find" combo box with the toolbox wizard. I then created
a sub in the AfterUpdate event of the control.

I typed in "With" in order to construct a With DoCmd... End With structure to
find a match for the combo box. But when I typed in a space after with, it
backspaced on itself and "with" turned red. To test further, I tried
everything I could think of (Dim, If, etc.) with the same result. If I type
with no spaces, I can add them afterwards and I can also type in just spaces.
But any VB functions or keywords backspace the spaces and turn red.

Any ideas?

Thanks,

Bill

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200605/1

This sort of thing can happen if you have an open form (even a hidden one)
with its Timer running.


"ragtopcaddy via AccessMonster.com" <u9289@uwe> wrote in message
news:5fa677400424c@uwe...
> Here's something I've never seen, heard of, or imagined before!
>
> I recently created a "find" combo box with the toolbox wizard. I then
> created
> a sub in the AfterUpdate event of the control.
>
> I typed in "With" in order to construct a With DoCmd... End With structure
> to
> find a match for the combo box. But when I typed in a space after with, it
> backspaced on itself and "with" turned red. To test further, I tried
> everything I could think of (Dim, If, etc.) with the same result. If I
> type
> with no spaces, I can add them afterwards and I can also type in just
> spaces.
> But any VB functions or keywords backspace the spaces and turn red.
>
> Any ideas?
>
> Thanks,
>
> Bill
>
> --
> Bill Reed
>
> "If you can't laugh at yourself, laugh at somebody else"
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200605/1

That is exactly the situation!

Thanks for the explanation

Bill R

John Nurick wrote:
>This sort of thing can happen if you have an open form (even a hidden one)
>with its Timer running.
>
>> Here's something I've never seen, heard of, or imagined before!
>>
>[quoted text clipped - 17 lines]
>>
>> Bill

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200605/1