Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Convert FMS Memo data into MS Access 2007 RTF Memo

Posted on 2008-10-24
6
Medium Priority
?
580 Views
Last Modified: 2013-11-27
I 'd like to upgrade an Access2003 application into Access 2007.
In Access 2003, there are some FMS Memo Controls and associated memo fields in the database.
I replaced FMS Memo controls with Access 2007 RTF text boxes and it's working fine.
I could save memos in RTF Format and retrieve them in the same format when required.

The problem is that the new Acces 2007 Memos are unable to display previous memo data  inserted by FMS Memo controls in Access 2003. It displays data as follows:

\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Arial;}}
{\*\generator Riched20 5.50.99.2014;}\viewkind4\uc1\pard\kerning36\fs24\lang4105 1) In order to comply to Clause A, it must be clear that they are ordering the product or that the bartender clearly knows them.\par
}

How we can display the data inserted with FMS Memo controls into the Access 2007 RTF Controls in it's original form without those tags and unwanted characters?

Please help me.
0
Comment
Question by:GeekHipster
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22799398
have you asked FMS?

http://www.fmsinc.com/
0
 
LVL 1

Author Comment

by:GeekHipster
ID: 22812281
I searched in their website, but couldn't find an answer.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points
ID: 22812461
did you try sending them an email, stating your problem?

i believe they are the most qualified to give an answer to your problem.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:GeekHipster
ID: 22815164
Yes..I 've sent an email, but not received reply yet.

Do you know how to convert RTF into HTML using Visual Bassic 6.0?
0
 
LVL 1

Author Comment

by:GeekHipster
ID: 22841268
Yes..I found the solution...
Thank you so much..Capricorn1..
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22841338
did you get your answer from FMS?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question