Why double underscore after control name

Why double underscore after control name

am 22.04.2008 07:07:52 von davjoh123

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___AfterUpdate()
ChangeKitBase Me.Kit__
End Sub

Re: Why double underscore after control name

am 22.04.2008 13:35:35 von Stuart McCall

wrote in message
news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s33g2000pri.google groups.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___AfterUpdate()
> 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.

Re: Why double underscore after control name

am 22.04.2008 14:10:53 von Stuart McCall

"Stuart McCall" wrote in message
news:fukiin$ni0$1$8302bc10@news.demon.co.uk...
> wrote in message
> news:1ea2dc43-2fbe-4921-8492-0f2099f7d1f2@s33g2000pri.google groups.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___AfterUpdate()
>> 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.

Re: Why double underscore after control name

am 22.04.2008 18:42:16 von u28780

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

Re: Why double underscore after control name

am 23.04.2008 00:11:38 von Salad

Linq Adams via AccessMonster.com 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.