I have a memo field in a MS Access table. The contents of the field may look
like this:
1. This is number one
2. This is number 2
3. Skipping lines is fun if your #3
But when I write it out to my web page using my ASP code {something like:
rsJobs.Fields(" notes") }
it looks like this on the web page:
1. This is number one 2. This is number 2 3.Skipping
lines is fun if your #3
How can I make it show up like it is in the memo field - it seems like the
carriage return / line feeds are being ignored or translated into spaces or
something
Can anyone help ?
Thanks,
Jim 2 6499
HTML doesn't respect white space -- imagine if it did?
<table>
<tr>
<td>foo</td>
</tr>
</table>
There would be a bunch of tabs and carriage returns rendered to the browser!
I'm glad HTML disregards this white space, otherwise we'd go absolutely
nutso maintaining strictly coded (and hence unreadable) HTML pages ... and
presentation would be tied to coding, yuck. The whole beauty of HTML is
that the code doesn't have to look anything like the presentation.
Remember that an ASP page is simply returning HTML to the browser, and that
when your memo column contains
line 1
line 2
This is what gets inserted directly into the HTML. So, to replace white
space, see http://www.aspfaq.com/2188
"Jim Plante" <ji*@repointing .com> wrote in message
news:JE******** ************@co mcast.com... I have a memo field in a MS Access table. The contents of the field may
look like this:
1. This is number one 2. This is number 2
3. Skipping lines is fun if your #3
But when I write it out to my web page using my ASP code {something like: rsJobs.Fields(" notes") }
it looks like this on the web page:
1. This is number one 2. This is number 2 3.Skipping lines is fun if your #3
How can I make it show up like it is in the memo field - it seems like the carriage return / line feeds are being ignored or translated into spaces
or something
Can anyone help ?
Thanks, Jim
<%= replace(rs("mem oField"),vbcrlf ,"<br>") %>
or
<p><%= replace(rs("mem oField"),vbcrlf ,"</p><p>") %></p> -----Original Message----- I have a memo field in a MS Access table. The contents of
the field may looklike this:
1. This is number one 2. This is number 2
3. Skipping lines is fun if your #3
But when I write it out to my web page using my ASP code
{something like:rsJobs.Fields( "notes") }
it looks like this on the web page:
1. This is number one 2. This is number 2 3.Skipping lines is fun if your #3
How can I make it show up like it is in the memo field -
it seems like thecarriage return / line feeds are being ignored or
translated into spaces orsomething
Can anyone help ?
Thanks, Jim
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: intl04 |
last post by:
I have a memo field that is included in some Access reports I created.
Is there some way for the memo field to display nicely formatted text,
with line breaks between paragraphs? Or is it necessary to export the
report?
I tried exporting a report by using the .rtf rich-text format (the
plain-text format was the only other word-processing option listed
when exporting). I then opened the .rtf file in Word. However, it
looks like some...
|
by: Lee Rouse |
last post by:
Hello all,
This is going to be a rather lengthy "question".
I have an Access 2k database, separated front end/back end. Front end
copies are on about 30 workstations and used frequently during the
work day. The backend has a table called CLIENTS with approximately
6000 client records. Changes to data in the table are made via a
frontend db Form which has CLIENTS as its record source.
|
by: mbev |
last post by:
I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me...
|
by: htmlgeek |
last post by:
I've beaten my head againts this for two weeks and would appreciate
any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000
and then 2003 and received same problems!
I've rebuilt pages etc. etc.
Insert and update work, but updating of records with data in the memo
field seem to crash/corrupt Access--but only on those records.
The problem seems to narrow down to updating a record's memo field. It
|
by: Scott Van |
last post by:
Hello-
I am trying to create an Access table using DDL that has a memo field.
I have the syntax to create the memo field but I can't find the syntax
to also set whether the memo field should allow zero length. I can set
this option using the Access interface directly, but I want to create
this table and this column definition using a DDL script. Listed below
is the script that works but I just need the syntax to set the
additional...
| |
by: Matt |
last post by:
I'm having difficulty with trying to update a Access memo field through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT INTO
sql command. Anyone know a way around this?
Sample
strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
|
by: Dave |
last post by:
I have a field with data type of memo in my access database. I run a
query from c# to access this field and it cuts off my string to only
255 characters. If i run this query directly in access it works fine.
If i run this query without the iif statement it works fine. It only
cuts off my string when i run this query in c# WITH the iif statement.
Here is the statement that doesn't work.
SELECT
IIF(ISNULL(t1.field1), t2.field1,...
|
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo field is printed within
the detailed area. The problem is, the apllication is not setup
properly, thus the users are entering data within the memo field as:
location1 1/1/2005 1/1/2006
|
by: Owen Jenkins |
last post by:
Following on from an earlier post...
I can reliably corrupt a record by doing the following ...
Open two separate but identical front ends on one PC each linking to the
same back end.
Edit a records in one front end and leave it unsaved.
Edit the same record in the other front end and save the change.
Save the change in the first front end - this pops up the Write Conflict
message to which I click Save.
|
by: steph |
last post by:
I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that vary
based on user selections. The input files are CSVs and can number from
2 to 175 columns. Each field is usually able to fit into a Text field
(< 255 characters) but every now and then a longer field creeps in.
since I don't know in which column...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |