[AccessD] datatype underlying bound control

Hi John

Returning to your original question, you can use VarType():

  intVarType = VarType(Forms("frmSomeForm")!txtTextBox.Value)

This requires, of course, that the form is open.

Your second question is another matter ...
What are you trying to do?

/gustav


> If the source is a complex query of 2 or 3 joined tables, how (other than
> parsing SQL text) do I determine the source table of the field?


> Yep, you can determine the field, and you can determine the source (that the
> form is bound too), so using those two pieces of information, you can open
> the source with ADO (or DAO) and determine it's data type.

> Let me know if you need help with the code.


> Is there any way to (easily) determine the datatype of the field that a
> control is bound to?