[AccessD] Current Control Name

In this example, Ctl1_IF ,I would want to suck out 1_IF which is the
name of the control.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, May 06, 2005 11:33 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Current Control Name

Karen;

Are you trying to glean the control's text or the control's name? I
don't understand what you mean by "pulling the text to the right of the
Ctl" -- to you mean 

controlname & controltext

Have you tried ctl.Name where ctl is an Access Control object? Not sure
that's what you're after though. 

Susan H. 

I have several controls on a form.  Each is named as Ctl1_IF.  I want to
be able to capture the name of each control, pulling the text to the
right of the Ctl and use it in calculations.  I am tired of typing it
over and over... and it is Friday so where is all the humor at?  Here is
an example of one of the pieces of code

Private Sub Ctl1_IF_AfterUpdate()

        If (me.[1-IF] > 99) Then
	me.result = "FAIL"
        End If


Question is, sucking out the name of the current control...

Thanks.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com