Dave No I don't think so. Let me explain
Table (mytable) with one field (myfield) with three records (having values "value1", "value2" and "value3") Grid has recordsource set to "mytable), recordsource type is alias. Grid has one column and I want the grid to display three rows, each with the apropriate value from the table displayed. The catch is that I do not want the active control in the column to be a textbox or other object with a controlsource. I need the column to have an active control (currentcontrol) which is a label (obviously it would need to be subclassed somehow) or a container containing a label. Don't worry at this stage why I need this <g>. If I can get this simple, prototype working I will have solved the problem and I can explain all ! Cheers Paul Dave Crozier wrote: > Paul, > You can set the recordsource up to be > > =User_Defined_Function(vParameter) > > And in the UDF you can retrieve and return any value you need. > > In your case you could pass the Grid recordsource for the grid I guess. > > Is this what you mean? > > Dave Crozier > > > And in the Function > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Newton > Sent: 07 June 2007 10:21 > To: profox@leafe.com > Subject: Faking it - ControlSource > > Hi all > > I have a grid and in one column I need to put a control which does not > have a native controlsource property. The column needs to have have > sparse set to .F. and each row in this column should have a > display/value dictated by a value from a table whci is the recordsource > for the grid. > > The simplest example might be that the control is a label and I need its > caption to be "bound" to the recordsource. Another example might be a > container whose contained objects need to have properties bound to the > recordsource. > > A third example might (?) be an ActiveX control (NOT oleBound) that I > want to behave like an olebound control - although I don't need this > right now. > > Can something like this be done ? > > Thanks > > Paul Newton > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.