Re: how come my memo field in access always trims the trailing spaces? acccess 97.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tim Ferguson (FergusonTG_at_softhome.net)
Date: 04/17/04 

Date: Sat, 17 Apr 2004 13:14:11 -0700

"James" <See.My.Sig@The.Bottom.com> wrote in
news:aYUfc.5450$Tw6.2254@chiapp18.algx.net:

>
> thats a lot more work to use sql for every thing, is that nessisary?

It depends. To be honest, although I did not follow everything you were
saying, I think I'd use a completely different approach anyway. I just
dont' believe in using a chisel to hammer nails: the text box was never
meant to be used for formatted text.

Have you thought of something like putting the text into html and using the
shtmldoc control?-- it's one of those things that should be theoretically
possible although I haven't tried it.

> where else would i need to put sql if i deside to go that route?

I really wouldn't... If I had to I'd probably do a separate dialog to enter
the text and put it all in the cmdOK_Click event... but I don't know your
db design.

I was only trying to explain where the problem lies with controlling white
space in text boxes.

All the best

Tim F

Relevant Pages

  • Re: SF: Doesnt work?
    ... Gianna Stefani wrote: ... >> I doubt she was honest to you, ... James mentioned that his father (whom I don't ... So do you think this is just projection on James' part, ...
    (sci.math)
  • Re: SF: Doesnt work?
    ... Gianna Stefani wrote: ... >> I doubt she was honest to you, ... James mentioned that his father (whom I don't ... So do you think this is just projection on James' part, ...
    (sci.crypt)
  • RE: Merge 2 different tables
    ... I have come accross the issue thats stopping the uery running properly. ... I was recreating the DB with the tables in that build up my SQL and ... The Temp DB I was sending you worked on the fact I imported the tables from ... My original idea was to ADO link from the SQL Server to my Access DB (not ...
    (microsoft.public.access.queries)
  • Re: Honest question - so why do scientists suport ToE?
    ... actually think the American Association for the Advancement of Science ... no, thats not the "scientific approach," thats the honest approach. ...
    (talk.origins)
  • Re: Factoring paper is wrong
    ... >Good James, you are being honest, which is better than many others! ... get sympathy from some people in newsgroup, ... he is a manipulative crank. ...
    (sci.math)