Force a carriage return/line feed in an Access Database on website

[SHIPP]

I have a field in an Access database that represents an address. The address
is in the database 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" & chr913) & 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.

Thanks in advance. I am using Access 2003 with Frontpage 2003.

 

[Kathleen Anderson [MVP - FrontPage]]

Are you using the Database Results Wizard? If so, this might help:
http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Line Breaks

You can also use HTML, just make sure you right-click on the field in Design
View and select Column contains HTML.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[SHIPP]

Perhaps I wasn't clear. Yes I am using the Wizard. I have data coming into
Frontpage in one field from Access. At specific points in that data I want to
execute a line feed and carriage return so that this when displayed in
Frontpage:

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

becomes this

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