line feed triggered by special key

[Guest]

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

 

[Rick Brandt]

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

While I disagree about putting this in the same field why don't you just have
them use an *actual* line-feed? Then you don't need any complex replacment
hanlding.