On Thu, 22 Apr 2010 01:14:01 -0700, Highlight between 3 fields
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]