[AccessD] <\Div>

Jim Hewson jm.hwsn at gmail.com
Tue Dec 22 09:02:57 CST 2009


I know this is a little late; I've been having email issues.  I could read
them, but not respond to them.
Anyway - if you're still looking for a solution.

The "<\Div>" is html for storing part of the RTF formatting of the memo
field I Access 2007.
It marks the beginning and end of a line.
It is seen when looking at the field contents in a datasheet or with Plain
Text chosen in the Text format of the field.  If you look at the field
through a form with the RTF turned on they won't show. 

To get rid of them there are a couple of things you can do...
1.  Ensure the format in the field definition in the table is Plain text.
2.  Ensure the format for each text box is also Plain text.
3.  Once the field definition and text box are formatted to plain text then
the markers will need to be deleted in each field.

If you want to maintain the RTF formatting...
1.  Do the reverse of the above -- turn on RTF at the record level and at
each text box 
2.  If you want to use the field in a combo box or list box the codes will
show up again...
However, there is an undocumented function named PlainText(fieldname) that
will strip the markers and convert the RTF for viewing as plain text.

HTH

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: Wednesday, November 18, 2009 7:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] <\Div>

I do not want it in the table and it is showing up when the user enters that
data in the form.
 
Dale

--- On Tue, 11/17/09, Gary Kjos <garykjos at gmail.com> wrote:


From: Gary Kjos <garykjos at gmail.com>
Subject: Re: [AccessD] <\Div>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Date: Tuesday, November 17, 2009, 4:16 PM


So you want that to show or you are wondering where it is coming from
or what?  That would appear to be some sort of HTML code delimiter or
something. Perhaps the form is just ignoring it as a formatting code
or something. The bigger question to me is how the heck did it get
into the table data if it's not supposed to be there.  Where did the
data in the table come from?  Was it entered from that form that now
doesn't show those delimiters?  If so then something on the form must
be adding them to the data.

Good luck figuring it out Dale.

GK

On Tue, Nov 17, 2009 at 12:23 PM, Dale Kalsow <dkalsow at yahoo.com> wrote:
>
> I am getting this <\Div>  at the begining and end of a text field. 
However it only shows up in the table and on a report not when the user goes
into the form.  Has anyone seen this before or have any idea how to fix it?
>
> thanks!
>
> Dale
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



      
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list