[AccessD] data type for field in a closed table

Susan Harkins ssharkins at bellsouth.net
Sat Jan 24 12:35:01 CST 2004


I'm trying to return a field's data type.

I have the field by name -- as a string -- and I just can't seem to get it
into a Field object variable so I can tap into the Type property. The field
is the result of a listbox selection.

varField = lstField.Value

How can I get from there to

fld = varField

to here

varType = fld.Type

Everything I've tried returns an Object required at the fld=varField
statement because varField is a string, not a real reference. At least, I
think that's the problem.

Or,  if I'm going about it entirely wrong, clue me in please. :)

Susan H.




More information about the AccessD mailing list