UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Field Name Of Current Cell In A Table, Access 2013    
 
   
AshJT
post Nov 12 2019, 10:12 AM
Post#1



Posts: 42
Joined: 4-June 08



Hi

Is it possible to get the name of the field from the current cell in an open Access table?

I can get the text in that cell with:

CODE
screen.activecontrol


Can I get the field name in a similar way?

Cheers!




Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 10:25 AM
Post#2


UtterAccess Moderator
Posts: 11,885
Joined: 6-December 03
From: Telegraph Hill


CODE
Screen.ActiveControl.ControlSource

--------------------


Regards,

David Marten
Go to the top of the page
 
theDBguy
post Nov 12 2019, 11:05 AM
Post#3


UA Moderator
Posts: 76,823
Joined: 19-June 07
From: SunnySandyEggo


I didn't realize ActiveControl works with tables too. Thanks.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 11:22 AM
Post#4


UtterAccess Moderator
Posts: 11,885
Joined: 6-December 03
From: Telegraph Hill


Haha! I had missed that it was used directly on a table (I thought it might be a form control or datasheet cell)

Interestingly, if you check the cell's ControlType it returns 115, which is not listed in the acControlType enumeration.

Other missing constant values are 113, 116, 117, 120, 121, 125. I wonder what they are!

d

--------------------


Regards,

David Marten
Go to the top of the page
 
AshJT
post Nov 12 2019, 11:47 AM
Post#5



Posts: 42
Joined: 4-June 08



Hah! wonderful, works a treat!

Thanks
Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 11:54 AM
Post#6


UtterAccess Moderator
Posts: 11,885
Joined: 6-December 03
From: Telegraph Hill


yw.gif

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th December 2019 - 01:26 PM