>Hi All
>
>Given a field name from a table is there a quick way to determine the fields properties iro type, length, decimals without using Afields() which gives properties for all fields?
>
>TIA
>
>Jos
You can get
some information with type() or vartype(). But I think you do need afields() to get the complete information. Why not create a UDF for this purpose, and post it here, under FAQ? To compare with the fieldname, I would use the field() function.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)