PC Access Flyer Reference Guide

for PC Access Flyer 1.02.022

Using @NULLVALUE

What is the @NULLVALUE command and when should I use it?

The @NULLVALUE command is most commonly used with the Immediate If (@IIF) macro. Not all listings contain values in every field. If a field is blank (or null) when you download MLS listings, the Flyer program substitutes the value specified in the Empty Field Text box of the Printing Options Group | Options window. The default value for the Empty Field Text option is <N/A>. If you want to check to see if a particular field is blank, compare it to the @NULLVALUE command. By using the @NULLVALUE instead of <N/A>, you won't have to change your templates if you later decide to change the Empty Field Text to something other than <N/A>.

For example, let's say you have the following text object in your template:

Type of Pool: |PROP_POOL|

If this field is blank from the MLS, in all likelihood you don't want the printed flyer to say:

Type of Pool: <N/A>

Instead, you would probably rather it said:

No Pool

To accomplish this, you need to be able to tell whether or not the PROP_POOL field is blank. Using the following @IIF macro you can create a more customized looking flyer without actually having to customize each one!

@IIF("|PROP_POOL|" = "@NULLVALUE","No Pool","Type of Pool: |PROP_POOL|")

No matter what you change the Empty Field Text to at a later date, the template will always compare the value of the PROP_POOL field to the current Empty Field Text.

Last modification date: Friday, January 17, 2003 00:58:18