[AccessD] Syntax question about control references

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