Translate captions in a Microsoft Access run-time application

Hi

I want to translate the forms in an MS-Access run-time application. I beleive that athis simply means that I have to translate the captions in the form.

Can someone confirm that translating the captions will not break the application?

Thanks!
LVL 1
vanaudenAsked:
Who is Participating?
 
stevbeCommented:
typically applications do not rely on the form/report captions (Access itself does not use them) so you should be able to safely change them. You will need to mdb version to write the code to do this at runtime or even to open the forms in design mode if you are going to make the chnages manually before deploying. You could to a quick search of the code (again in the mdb version) for .Caption and see if there is anything odd going on.

Steve
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Define 'translante the captions'.
0
 
GRayLCommented:
In a run-time app, I don't believe you have access to form/report captions.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
nico5038Commented:
You can never be 100% sure that this won't break the application.
I regularly fill captions dynamically and even use their value sometimes in my code.
Only changing it and test the application afterwards will give the outcome.
Like Steve stated, you'll need to have the .mdb version of the database.

Nic;o)
0
 
vanaudenAuthor Commented:
I do have the MDB version of the DB and I am able to directly edit each form in FORM VIEW in Access.

I would define translating the captions as translating the Visual Basic Caption Property in the Access form. I would do so by right clicking a term "Enter Name:" that would describe a form field... Ex:   Enter Name: ________________.

I want to be clear that I would not be translating the NAME PROPERTY, which I know is used in the code.
0
 
nico5038Commented:
Opening the form in design mode and clicking on the caption when displaying the properties window will allow you to change the caption manually in the Caption property under the Format tab.

Start with making a backup copy, change all captions and then test your application.

You could open the VBA code behind a form and perform a Find for the string ".caption" to see or some code is referencing a caption.

Nic;o)
0
 
vanaudenAuthor Commented:
Thanks much everyone!
0
 
GRayLCommented:
Actually, what I think you are talking about are labels.  All forms and labels have a caption property which you should be able to translate (into another language?) without problems provided there is no action programmed against the contents of any of these captions.
0
 
vanaudenAuthor Commented:
Hi GRayl

I think you are right about the "label" word and thanks for the supporting info!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.