[AccessD] Chinese Language

Dear List:

It seems that I can change the caption of a control through code:

ctl.Caption = rs(gstrLanguage)

' Where gstrLanguage is the field name in the language table of the language
selected by the user

but I can't change the font:

If InStr(1, gstrLanguage, "Chinese") <> 0 Then ctl.font = "Arial Unicode MS"

gives me 'object soesn't support this property or method'.

Is there a way to change the font of a control?  This code will be running
in an mde so opening the form in design mode isn't an option.

MTIA

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, April 30, 2004 7:11 AM
Subject: Re: [AccessD] Chinese Language


> Dear List:
>
> OK.  I'm making some progress.  I changed the font on one of the labels to
> Unicode MS copied the Chinese characters from the Excel spreadsheet to the
> Caption in the property sheet for the control, and viola! it displays
> Chinese!  When I look in my Access Language table, however, I still have
> little boxes.  The caption also shows as little boxes in the property
sheet
> of the control.
>
> I haven't written the public function yet to take the Chinese from the
table
> and put it into the caption (the function will also, I guess, have to
change
> the font to Arial Unicode MS), but I'm concerned that it may show boxes.
>
> Maybe I should stop bothering you all and see how far I can get on this by
> myself.
>
> But I have to tell you it's very exciting.  In the old DOS days I did a
> Chinese language version of this product with this woman in Taiwan and I
> remember the thrill the first time my Main Menu came up in Chinese.
>
> Still, if anybody has any advice for me, it's appreciated.
>
> Regards,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
>
>
> ----- Original Message ----- 
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: <AccessD at databaseadvisors.com>
> Sent: Friday, April 30, 2004 6:45 AM
> Subject: [AccessD] Chinese Language
>
>
> Dear List:
>
> I am trying to create a Chinese language version of my product with the
help
> of a contact in Taiwan.
>
> As an initial test she translated the captions on the Main Menu.  I
created
> a front-end language file table to hold the two forms of Chinese (simple
and
> complex) and can add fields as I add languages.
>
> I sent her the table but she sent back an excel file of the table with the
> translations.  When I open the Excel file the Chinese characters display
> correctly (of course, how would I know?).
>
> But when I copy one of these strings from the Excel cell into the language
> table in Access it shows as squares - undisplayable character, I assume.
So
> Excel displays the Chinese but not my Access.
>
> I'm stating down the Access Help route but if anyone knows how to get
Access
> to display foreign characters can you give me a lead?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com