Hello all,

I've got a record with about 100 fields that I would like to save to a pdf and then to have printed.

But before saving and printing I would like to replace all the empty edit fields with "N/A".

I've done Find/Replace with "=" into the Find field. But this doesn't seem to be working...?

I've tried """", but no luck with this either.

What might I be doing wrong?

Any guidance would be greatly appreciated....

Thanks.

What you are looking for in Replace Field Contents. However, IMHO storing N/A in the field may not be the right thing to do just for printing. You can various methods to display N/A including creating a new layout and using merge fields, merge variables, etc to display the data or N/A.

Mr_vodka,

Thank you for your response.

If I were to create a new layout, specifically for printing, I would then do a calculation to replace field contents if empty?

However for our record keeping I cannot see any harm in having a "N/A" as a value. I would consider my original plan if it is much easier to implement.

I would appreciate your opinoin.

Thank you

No you can use Replace Field Contents if you have to replace all values in your found set for a particular field ( in your example after the find ).

This may be slightly off the topic, but there are very few things that require 100 fields to describe them. It's possible, even likely, that you have a structural issue. If so, this task could be significantly easier if you fixed the structure first.

I cannot see any harm in having a "N/A" as a value.

They are hardly the same thing. In any case, you could either replace the field contents, or use conditional formatting to display the text "N/A" when a field is empty. Both solutions are extremely tedious to implement with 100 fields - hence the suggestion above.