I wonder if this is possible?
I have a tale named tCBZ that serves as a data source for the form named fCBZ. The table has several fields, including the Short_Name and Long_Name fields. On the fCBZ form, only the Short_Name field is used(because it is shorter
). However, for some records the field is blank. In this case, that is, when the Short_Name field is empty, I would like to use the Long_Name field as a data source.
So I'd like to do something like
if Short_Name is blank then show Long_name else show Short_Name
Is it possible and what do I have to do?