Solved

Determining control field type (from the form control)

Posted on 2016-11-30
4
27 Views
Last Modified: 2016-11-30
Is there a fast/clean way of determining the field type (directly from the form)?  I have a function that creates a shortcut menu when a control gets focus (pretty much every field/control on the form will do this).  

Some of the options on this shortcut are in relation to filtering, and I want to be able to determine the actual field type (not the value within the field).  I know that I can pole the table directly with something like this (ctl.name is the field that has focus).

currentdb.TableDefs("_tblMain").Fields(ctl.name).type

However, if there is a better way without looking at the table directly, I think it might be more efficient.
0
Comment
Question by:Andy Brown
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 41907067
I don't think the Form itself has any knowledge of the Datatype of the fields bound to controls. Your method should work fine, but unless you're using the Field name as the Control name (which is a bad idea), then you would need something like this:

CurrentDb.TableDefs("Table1").Fields(Me.Worked_Department.ControlSource).Type

The highlighted portion would be changed for each control.
0
 

Author Closing Comment

by:Andy Brown
ID: 41907082
Yep - I just spotted that one :O)

Thanks for the help.
0
 
LVL 57
ID: 41907086
A better option, although less automatic, would be to use the controls tag property.  

 This would give you more granular control over what controls allow for filtering, and the type of filtering that should be used.

Jim.
0
 

Author Comment

by:Andy Brown
ID: 41907091
Thanks Jim (as always).  I'll take a look.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question