Arthur Fuller
artful at rogers.com
Tue Sep 7 20:40:05 CDT 2004
Works like a charm, Chris! Thanks. Now I just have the remaining and strictly cosmetic problem, but the interface screams out for it, and if I could deliver it I know the users would have spiritual orgasms. The way is datasheet form is currently laid out, the column corresponding to today is positioned at the extreme right of the visible part of the form. Column 1 of the form is invisible. Column 2 is frozen. I would LOVE to somehow scroll the columns so that the column selected using your code is the first visible scrollable column. Is horizontal scrolling somehow programmable? Thanks again. Two clean lines of yours plus a Dim of mine and it's smooth as glass. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mackin, Christopher Sent: Tuesday, September 07, 2004 11:17 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Syntax question about control references strCtlName = CStr(eom(date)) Me(strCtlName).SetFocus Should work. -Chris Mackin