Michael, Miss out the "=" if you are doing it at design time. Dave Crozier
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 16 January 2007 14:08 To: profox@leafe.com Subject: Re: Showing the time only portion of a VFP datetime field ina gridcolumn Dave Crozier wrote: > Michael, > > Controlsource="=Substr(Transform(Datetime()),12)" > > Dave Crozier > This didn't work for me, with VFP8 complaining about it needing to be a variable reference. Can it only be done programatically instead of in the Properties box? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [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 ** 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.