Re: How can I convert text field to memo field in a query

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am presuming that it displays correctly when you open the query in Access?
If so, could you show us a typical result that displays correctly in Access
but incorrectly in Wordpad (have you tried Notepad instead?)?

efandango wrote:
Bon,

this is the string I am trying to output:

KML_Address: "<Placemark><name>" & [Venue] & " (List" & [List_No] &
")" & " </name><address>" & [Address] & ", " & [Postcode] &
"</address><description>" & " LOL:" & [LBy1] & "<br>" & " LOR:" &
[LBy2] & "</br><br>" & " LOL:" & [LBy3] & "</br><br> LOR:" & [LBy4] &
"</br>" & "</description></Placemark>"

but when I open up the text in wordpad, near to the end (in varying
lengths), I get a sequence of characters like this: ????????????????

I'm a bit green at this, so perhaps, it is not max chars issue, but I
don't know how to resolve it.

"Bob Barrows [MVP]" wrote:

efandango wrote:
I have a one table query with a user defined memo field.

Address:

how can I convert this field from a text field to a memo so that the
output can handle more than 255 characters?

Could you show an example where the output is limited to 255
characters?
An expression should not be limited to 255 characters. For example:

SELECT len([Expr1]) from (
SELECT String(300,"a") AS Expr1
FROM [TableContainingOneRecord])

returns 300 for me. I'm not clear why any conversion is necessary,
unless you are storing the data or displaying it in some control
that is limited to 255 characters.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Ligatures [was: Re: The -s plural in English nouns]
    ... Agent newsgroup where you could raise the point and see if ... ASCII characters, either of the things you've mentioned ... I never said anything about my using Lynx; ... commenting on with respect to looking in an Agent newsgroup ...
    (alt.usage.english)
  • Re: How to Limit Memo to 1500 Characters
    ... Something like "Please enter less than 1500 characters." ... In Design view, select the memo field. ... Now if you wish to use a Validation rule you can. ... Please respond only to this newsgroup. ...
    (microsoft.public.access.forms)
  • Re: Different number of Chinese characters per line in MS Word
    ... You may want to use the link below to also post this in the Word International Features newsgroup. ... I have a MS Word 2000 document in Chinese characters. ... characters as the original document, even though all format settings in two ...
    (microsoft.public.office.misc)
  • Re: Re: LAW requires 10-pitch
    ... average number of characters per line and by 6 to derive the cpi. ... please post all follow-ups to the newsgroup so ... > This is the rule for proportional spaced fonts -- it needs to average ... >>incoming briefs to make sure they meet formatting requirements. ...
    (microsoft.public.word.printingfonts)
  • Re: Aligning text in tables
    ... the different font characters (which may ... If the font character seems to ... please post all follow-ups to the newsgroup so ... > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ...
    (microsoft.public.word.tables)