Avatar of Sandra Smith
Sandra Smith
Flag for United States of America asked on

Keep indents user has typed and recorded in Database in in email body

I have a jprocess that creates an email from user input into an ACCESS database.  It works find except teh user may indent items in the text box on the form.  say they input:

Todays Project
    - Keep going

Is there a way when the record is returned from the select statement to keep this indentation?  There woudl be severa layers and they want it to appear like this in the email.  This is not spacing that is controlled in the email code, but spacing that is recorded in the table in ACCESS itself.  Hope that made sense.
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment
Richard Daneke

8/22/2022 - Mon
Francis Omoruto

If it's an HTML email body, you can just suround the text with <pre>...</pre> to keep the formatting.
Sandra Smith

ASKER
Yes, it is HTML and thank you.  I will test and get back.
Sandra Smith

ASKER
Actually, below is a sample, where would I put this code?
        strMailBody = strMailBody & "<br /><Font Color=Black>" & "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-" & ![Update] & "</Font>"
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Richard Daneke

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Badotz

>>If you use a memo field in the database, it can be set to rich text to preserve the formatting of the user.

Be aware that memo fields come with their own headaches:

http://allenbrowne.com/ser-63.html
http://objectmix.com/ado-dao-rdo-rds/50498-using-getchunk-read-memo-field-access-database-crashes-windows-xp.html
Sandra Smith

ASKER
This is an ACCESS 2003 database and I am trying to figure out how to set to rtf.  That choice does not appear in the format property.
Sandra Smith

ASKER
While I think ACCESS 2003 cannot be done, I did find that for other clients with 2010, this did seem to work.  Thank you.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Richard Daneke

rtf format for memo fields was introduced in 2007 and continues in 2010.
The option was not available in 2003 and earlier versions.