[AccessD] Syntax question about control references

Hi Arthur

That would be

  ctl = Me.ActiveControl

/gustav


> Interesting. Gonna try this right now. Gonna have some interesting
> calculations to do. Question, though. Given that the focus has been
> placed in any given column, how can I determine which column the focus
> is in? I don't want to do it by name, I want to do it by number. I.e.
> the current date is 9/10/2004, which places me in column 9/30/2004,
> which happens to be column 12 of the scrollable columns. So I can derive
> which column to go into, I'm already there, but how do I determine which
> column number it is? Is there a way to determine which column number I'm
> in?

> A.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Wednesday, September 08, 2004 3:33 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Syntax question about control references


> Hi Arthur

> You could try playing with the GoToPage method:

>   Forms("frmYourForm").GoToPage 1, x, 0

> where x = ([count of columns to move] + Offset) * [Width of column in
> twips]

> If you succeed somehow please let us know.

> /gustav