Microsoft Access 2010 symbols arent transfering from Word

I am converting a 2010 Word document to an access database. I am copying from word and pasting into access, everything transfers but the symbol for "diameter" "perpendicular" "square root". Any suggestions.

Thanks in advance.
avoskinarianAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
Left column - simple text, right - memo field
memo.png
0
 
als315Commented:
You can change field type to Memo and set Text format to RTF
0
 
Billy_LondonCommented:
does it display correctly on a form control when you use the same font as you were using in Word?
It may display a square symbol in table view, but once in a control with a standard font like Verdana, it will display correct symbol.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
avoskinarianAuthor Commented:
@ als315, when i changed the 2 fields, i still recieved an error

@ Billy The error occurs in form view, when using a basic font like Verdana.

May have to use "alt codes" for those special symbols
0
 
Billy_LondonCommented:
the symbols transfer OK when I try it - that's using Office 2007. If you paste it into another application, such as notepad, do the symbols persist?
0
 
avoskinarianAuthor Commented:
@ Billy - No Good

When i copy and paste to note pad


What should be
Ø1.0455 – 1.0505
Is
¿1.0455 – 1.0505
0
 
Billy_LondonCommented:
maybe it's an encoding issue
did you get the word document from a different country?
i would try saving the word document again making sure it's in unicode.
see http://office.microsoft.com/en-us/outlook-help/choose-text-encoding-when-you-open-and-save-files-HA010121249.aspx
0
 
avoskinarianAuthor Commented:
@ALS I changed all the fields to memo and still get the same resuls

i attached a sample so you could see what i am dealing with
sample.docx
0
 
Billy_LondonCommented:
although the symbols display correctly in Word, they appear to be slightly different to the ones if I manually choose insert > symbol. I get the same symptoms as you - it replaces the symbol with a square symbol in notepad, but the new symbol copies correctly. Bizarre behaviour. Can you do a search and replace so that the old symbols become the new ones?
0
 
als315Commented:
Data were copied from yor document
DB26835169.accdb
0
 
avoskinarianAuthor Commented:
@als what are the differences between the 2 columns
0
 
als315Commented:
First standard text feeld, second - memo field and in properties of memo field RTF format for text was selected.
0
 
avoskinarianAuthor Commented:
@ALS, ok, i can now mirror your results, i can type cerain character into the table and it is transfered correctly. Now the formal data entry screen pulls up a subform / subreport, when it does that those same correct character get all jumbled. Is there any solution ?
0
 
als315Commented:
Can you upload part of your DB with this forms (reports)?
0
 
avoskinarianAuthor Commented:
@ ALS is there any way to control the font of the copied character. When i paste them, they keep the original font, and it looks different compared to the other fonts.

PS. Thanks for solving the main issue
0
 
als315Commented:
It was main idea - save original (Word) fonts. There could be different fonts for (symbols, for example) used.
You can try set  font in Word same to used in Access (usually - Verdana).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.