[AccessD] Create parameter that holds the source control?

Michael R Mattys mmattys at rochester.rr.com
Mon Jan 8 03:40:21 CST 2007


Hi Sander,

Something like this might do it for you ...

Function ZoomBox (ctl As Control)

    Dim strControlName as String
    Dim strParentName as String

    strControlName = ctl.Name
    strParentName = ctl.Parent.Name

End Function

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Sad Der" <accessd666 at yahoo.com>
To: "Acces User Group" <accessd at databaseadvisors.com>
Sent: Monday, January 08, 2007 4:23 AM
Subject: [AccessD] Create parameter that holds the source control?


> Hi,
>
> I need to create a zoom form.
> E.g.: I've got a textbox that can store let's say 200(+) chars. I don't 
> want to create a textbox that large.
>
> So if the user double clicks on it I want to open a form with a large 
> textfield. The user can type the info in this large textbox and send the 
> data back after pressing ok.
>
> Sounds easy....
>
> I've created a function that does this. However, it's not generic.
> I want add a parameter in wich I store the Form and Control of it's 
> origin.
>
> How do I create a parameter in wich I store the 'source control'?
> This parameter is later used to return the data to the correct control.
>
> Regards,
>
> Sander
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list