data - any number, date, time or timestamp
expression, or a
field containing a number, date, time, timestamp, or container
The data returned can be a field type number, date, time, timestamp, or container.
For a container field, GetAsText returns external path information, text (when the container contains text that does not resolve into a valid path), or a question mark (?) if the container data is embedded in the database. For container data stored externally, data is returned in the format shown in the following example:
“You are ” & GetAsText(DaysDelinquent) & “ days late.” returns
You are 3 days late. when the value of DaysDelinquent is 3.
“FY” & GetAsText(FiscalYear) returns
FY98, if the FiscalYear number field contains 98.