Prev: Duplicate Record command
Next: Subforms
From: John W. Vinson on 22 Apr 2010 22:08
On Thu, 22 Apr 2010 01:14:01 -0700, Highlight between 3 fields
<Highlightbetween3fields(a)discussions.microsoft.com> wrote:

>Hi
>
>Thank you for information
>
>I did test it and it work, but it didn't changed the caption on form.
>Though the important is that be changed on form.

It wouldn't, unless you recreate the control on the form. The table Caption
property is the default for new controls, but would not change existing
controls.

>Is it possible to make the text on caption as link to another table or
>something else to show the new text?

I expect it would be possible but it would take some code. The caption
property isn't exposed all that well in the table structure. You might want to
have your own table of fieldnames, languages, and captions and put textboxes
(rather than labels) on your form to look up the appropriate caption for the
user's preferred language.
--

John W. Vinson [MVP]
From: Highlight between 3 fields on 23 Apr 2010 02:51
> I expect it would be possible but it would take some code. The caption
> property isn't exposed all that well in the table structure. You might want to
> have your own table of fieldnames, languages, and captions and put textboxes
> (rather than labels) on your form to look up the appropriate caption for the
> user's preferred language.


Hello

Well, let make new table that namn "language"
have columns with name FieldName , CurrentWord, NewWord

So do you mean?

Can you please show me which kind of code that be on "Onload Form" to change
one caption to let me understand, then I can continue.

Thanks a lot
From: John W. Vinson on 23 Apr 2010 11:52
On Thu, 22 Apr 2010 23:51:01 -0700, Highlight between 3 fields
<Highlightbetween3fields(a)discussions.microsoft.com> wrote:

>> I expect it would be possible but it would take some code. The caption
>> property isn't exposed all that well in the table structure. You might want to
>> have your own table of fieldnames, languages, and captions and put textboxes
>> (rather than labels) on your form to look up the appropriate caption for the
>> user's preferred language.
>
>
>Hello
>
>Well, let make new table that namn "language"
>have columns with name FieldName , CurrentWord, NewWord
>
>So do you mean?
>
>Can you please show me which kind of code that be on "Onload Form" to change
>one caption to let me understand, then I can continue.
>
>Thanks a lot

I'd add one more field to the Language table: Language. And you probably
don't need the CurrentWord field. For instance you could have records like

Language; FieldName; Caption
English; FirstName; "First Name"
German; FirstName; "Vorname"
Spanish; FirstName; "Nombre de pila"

In the form's Load event you would assign the Caption property of each control
on the form to the appropriate value from this table for the user; I'd presume
that you would have the user's prefeered language in a global variable or a
control on a startup form.

This is a simple untested solution to what could be a more complex problem,
but I hope this gives you some ideas!

--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2
Prev: Duplicate Record command
Next: Subforms