Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2007

Tip: Looking for answers? Try searching our database.

Selected column in Datagrid

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lwidjaya - 29 May 2007 20:10 GMT
Is there a way to find out which column is selected/highlighted in datagrid?
I tried using "SelLeft" but it always gave me "1".

Thanks in advance.
Albert D. Kallal - 30 May 2007 00:55 GMT
> Is there a way to find out which column is selected/highlighted in
> datagrid?
> I tried using "SelLeft" but it always gave me "1".
>
> Thanks in advance.

Do you mean a listbox, or a continues form, or a 3rd party data grid
control?

SelLeft was never application to  your question in any context....

Remember, a listbox, or a continues form looks very similar. Here is some
screen shots of what I mean:

Also, it depends in terms of what context. If you have data displayed in a
grid like format (a continues form), then you can pick up the current
control via code such as:

screen.ActiveControl.Name

The above would return the current controls name. However, if you click a
button, then the active control is now the button you clicked (and the focus
has moved/changed. So, what context you trying to do under is also very
important.

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Albert D. Kallal - 30 May 2007 00:56 GMT
opps, those data screen examples of how a listbox, or contineus form looks
simular is here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.