>>>Hi all,
>>>I'm trying to use the MSForms Textbox to display some Chinese characters. I can enter the data in Chinese (using copy & Paste) but I can't save the data to a table and then display it. I'm just getting ????? instead of the original characters.
>>>
>>>Does anyone know the way around this?
>>>Many thanks.
>>
>>Are you using CAST()? Are your type designations beginning with "N"?
>Terry,
>Sorry you've lost me totally - I was just taking the TextBox.Text and replacing that into the tables memo field. I guessed that there was something more complicated that I should be doing but.....
>
>Many thanks for any help you can give me.
I am only aware of approaches that implement UNICODE and TSQL. The CAST() TSQL command (
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp ) and unicode SQL table fields (begin with an N).
We have an expert on this board - BILL SANDERS - but he must be fishing or making a fondeau!
Imagination is more important than knowledge