Why double underscore after control name

[davjoh123@yahoo.com]

Control name on form is "Kit #"

The afterupdate event that fires for this control calls the control
Kit__ as per following.
What is happening here?

Private Sub Kit___AfterUpda te()
ChangeKitBase Me.Kit__
End Sub

[Stuart McCall]

Re: Why double underscore after control name

<davjoh123@yaho o.comwrote in message
news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s3 3g2000pri.googl egroups.com...

Control name on form is "Kit #"
>
The afterupdate event that fires for this control calls the control
Kit__ as per following.
What is happening here?
>
Private Sub Kit___AfterUpda te()
ChangeKitBase Me.Kit__
End Sub

The behaviour you are seeing is a consequence of using punctuation
characters in control names. Change the name of the control (plus any
references to it) and all will be well.

[Stuart McCall]

Re: Why double underscore after control name

"Stuart McCall" <smccall@myunre albox.comwrote in message
news:fukiin$ni0 $1$8302bc10@new s.demon.co.uk.. .

<davjoh123@yaho o.comwrote in message
news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s3 3g2000pri.googl egroups.com...

>Control name on form is "Kit #"
>>
>The afterupdate event that fires for this control calls the control
>Kit__ as per following.
>What is happening here?
>>
>Private Sub Kit___AfterUpda te()
> ChangeKitBase Me.Kit__
>End Sub

>
The behaviour you are seeing is a consequence of using punctuation
characters in control names. Change the name of the control (plus any
references to it) and all will be well.

I just realised I didn't actually answer your question. The reason Access
changes the name is because special characters aren't allowed in procedure
names.

[Linq Adams via AccessMonster.com]

Re: Why double underscore after control name

And the # is the character Access uses to delimit literal dates.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

[Salad]

Re: Why double underscore after control name

Linq Adams via AccessMonster.c om wrote:

And the # is the character Access uses to delimit literal dates.
>

You can concatenate "Display This#http://www.nowhere.com " to create a
hyperlink. I think it's a shame that the # character was used as people
may use the # sign to denote a number in the display part of the hyperlink.