Access Database Used in Frontpage

S

SHIPP

I have a database in Access that I am feeding to my website via the Database
Wizard in Frontpage. I am using Access 2003 and Frontpage 2003.

I have a field in an Access database that represents an address. The address
is in the database in one field as:

1234 Stillwater Rd Stamford, CT 06904 (999) 111-2222

When it gets to the web site I want it to display as

1234 Stillwater Rd
Stamford, CT 06904
(999) 111-2222

I have tried to put chr(13) and chr(10) after each line to indicate a break
as follows:

"1234 Stillwater Rd" & chr(13) & chr(10)

That doesn't work.

I have tried to put a <p> and a </p> at the beginning and end of each line
break. That doesn't work. The website simply shows <p>1234 Stillwater Rd</p>

I would sincerely appreciate any guidance on what character(s) to put within
the field to force a carriage return/line feed when the field gets over to
Frontpage.

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top