I have designed a form that pulls demographic information from the
database. What I need is a way to put a line in if the information is
missing.

For example, I may have the person's name, but not their address. The
form now puts the name in properly, but leaves a blank for the address.
What I want is a line so the recipient will have a place to write in
their address. The same may apply for other fields (phone number, fax
number, SSN, etc.)

I don't want there to be a line if the information is already in the
database.

Thanks,

Rich Sagall

I would recommend using the isempty() function. Something like:

If(IsEmpty(Address);"___________________________"; Address)

Jay
"Rich Sagall" <rich.sagall (AT) pobox (DOT) com> wrote

You could also make each entry in the form filled with a certain number of
spaces by default when a new record is created. Then if no entry has been made
yet, address might default to " " or
"___________________________"

Kent

"J" <jw_in_in (AT) yahoo (DOT) com> wrote