Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/knoblecpa1/blog.knoblecpa.com/wp-content/plugins/post-credits/postcredits.php:1) in /home/knoblecpa1/blog.knoblecpa.com/wp-content/plugins/si-contact-form/si-contact-form.php on line 2189

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/knoblecpa1/blog.knoblecpa.com/wp-content/plugins/post-credits/postcredits.php:1) in /home/knoblecpa1/blog.knoblecpa.com/wp-content/plugins/si-contact-form/si-contact-form.php on line 2189
Act! – Script for City, State & Zip | David Knoble, CPA, PLLC

David Knoble, CPA, PLLC

Logo - white background

(click for our web site)

America Counts on CPA’s


Helpful Links

These links will help you nav­i­gate to other web resources for your orga­ni­za­tion, busi­ness or family.

Act! — Script for City, State & Zip

When cre­at­ing reports in Act! some fields need com­bined to print with bet­ter spac­ing.  For exam­ple, the city field in the con­tact data­base has vari­able length names.  Unless they are com­bined, the spac­ing between the city and state will be awkward.

In the Act! report writer, fields are manip­u­lated using scripts.  Cre­at­ing a cus­tom text box is beyond the scope of this post.   The script used to com­bine the fields is shown below.

Notice the amper­sands between each field or block of text.  More impor­tantly, notice there is no space between any of the strings or fields.  Putting spaces in the script when adding text fields together will not work.

Now the cus­tom text field can be used as if it were one large field with the City, State and Zip Code.  Using one field looks much cleaner and makes the report cre­ation much easier.

© 2009, david.knoble
by David Kno­ble, CPA, PLLC
Serv­ing Non-Profits, Busi­nesses & Indi­vid­u­als
Rock Hill, SC

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>