Pete --

Cetin had it right....all three parts of the DBGETPROP command require quotes. An easy mistake to make is to not have quotes around alias.fieldname so the actual correct syntax is:

=DBGETPROP("alias.fieldname","Field","Caption")

Note that in your original post, no quotes around alias.fieldname.


>>>Using DbGetprop to retrieve the "Caption" property I receive the above error, my code is as follows Dbgetprop(alias.fieldname,'Field',Caption')
>>>TIA
>>>Pete Kane
>>Pete,
>>Seems you only missed the quotes.Dbgetprop("alias.fieldname",'Field',"Caption").
>>Cetin
>
>Cetin,
>sorry I forgot the quotes in my message but not in my code, this is a real puzzler
>Pete