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 - 05 Nov 2006 23:14 GMT
> Hi,
> I made a table with just one address line, and some people want a 2nd
[quoted text clipped - 12 lines]
> 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.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com