K
Karl H
Hi,
I made a table with just one address line, and some people want a 2nd line
for Apt or suite, or PO box.. Rather than add another field to the table, I
would like to have them separate the 1st & 2nd address line with a special
key, like an asterisk.
Then, I want the asterisk to trigger a line feed on a report to print the
extra line, and lower the city/state text box down a line, too.
On the report right now, the data field=Address
I need an if then statement to find the asterisk, and, if present, trigger
vbcrlf
Thank you,
Karl
I made a table with just one address line, and some people want a 2nd line
for Apt or suite, or PO box.. Rather than add another field to the table, I
would like to have them separate the 1st & 2nd address line with a special
key, like an asterisk.
Then, I want the asterisk to trigger a line feed on a report to print the
extra line, and lower the city/state text box down a line, too.
On the report right now, the data field=Address
I need an if then statement to find the asterisk, and, if present, trigger
vbcrlf
Thank you,
Karl