What's that data from? I don't recognize the format.

That looks like rich text file (RTF) format.  SQL Server can only store plain text (as do relational database in general).  Access can store RT but in HTML format, not RTF.

Copy the data in your picture to a *text file* (.txt), then rename the file extension to the .rtf extension.  Open it in Word and you should see the formatting.  But of course you don't want to do this every time.  So it's generally not good practice to try to store rich text in SQL Server.  

If you must do it, use Access HTML rich text format, so you can at least see the formatting on an Access form.  See pictures below.  Set the textbox to show rich text.  The form will show the format, but the table will show it as plain text as I said.

Thanks Kevin, I want to tip you ... lol ..

hello Richard, the data was from my backup bak file. I bought your sql server seminar and found that u only taught import data from access to sql server. However i need the opposite, it is exporting data from sql server to access and then no more sql server again. i learnt a little bit from google and restored the bak file to my access . It appeared "wrong codes" in the above attached pic.

will try to fix it as suggested by Kevin

Hello Kevin, just tried your method and it works very well

thanks again, you are awesome

Dear Richard

"\f1\fs26\'ac\'47 \'a4\'a3 \'a9\'79 \'a4\'75 \'a7\'40 \'a4\'ce \'bb\'dd \'ad\'6e \'af\'66 \'b0\'b2 \'a5\'f0 \'ae\'a7 \b\f0\fs24 "

are  Chinese characters after  rtf  conversion and that why you didnt recognise it , thanks again for your reply

I've found the easiest way to move data from SQL Server to Access is to connect to the server via linked tables and then just run an append query to pull the data down.