Recent content by JoséBob

Hi, in the end, I used a very un-nice way for the multilingual UI : I have on my main form a dropdown menu for selecting the language. On Dirty, it'll reload the form and all the Captions of the elements on the form will get their new value from a table. I have coded a line that "dlookup" every...

Hi, Coming back to close this thread. In the end, I used the replace() to remove the html tags. I also used it to avoid to many of them when highligthing the changed word otherwise I would have had too many of them. Again, I am not sure using the replace function was the right one, but it...

As stated before in the thread I have several translation stored in a table. One on the many translation is to be displayed through msgbox. I have some text with linebreaks for clarity. Something of the sort : Text, text, text Text So, in my table I have written the string I thought I could...

One more question : I have certain msgbox of which the text shall be different depending on language. Using the simple code as NewMsgBoxTxt = DLookup("[" & LangVar & "]", "LanguageTable", "[Ref_Call]='cmbSearchTxtBox1'") MsgBox NewMsgBoxTxt It works fine. My only issue is that I want to have...

Many Thanks @MajP and @arnelgp I'll have a look at the example and the structure in detail. And thanks to the others for the answers on the dlookup.

Hello Mike, At that time I was still working (iteratively) on the structure of the code and thus not with variable but you're giving me the proper syntax if I want to use variable (thanks). At some point I will use a public variable to be able to read it from all forms and reports.

Thanks for the answer. We could open another thread about how to build a multilingual UI :) because I wasn't sure about the best way to do it.

Thanks for the detailed answer and indeed some questions arise. I wouldn't write here the description as I develop on a computer with Access in French. The idea behind the issue is a try to make a multilingual UI. Each objects (label, dropdown, etc.) will load their caption based on the language...

it works indeed. Do you know why?

The first one ([German]='German'") doesn't work but the second ("[FieldRef_123]='Abc'") does. I forgot to mention that both columns are identically parametrised in the table (short text)

Hello, I have a runtime error when using a DLOOKUP function. The code is following : StrValue = DLookup("[English]","LanguageTable","[German]=German") StrValue = DLookup("[English]","LanguageTable","[FieldRef_123]=Abc") it is indeed strange, but the first line is just to show that it works with...

Using plain text is, in my case, a little bit brutal. I need to keep the line breaks (marked automatically with <div> and </div>), thus only removing the formatting <font style=blabla> </font>.

Thanks to Isladogs for the link to the detailed site. Can I use the replace() to remove the rich text tags? to clear all formatting. i tried but it seems the replace doesn't find the tags.

Hei. Thanks for you reply. It is indeed useful. btw, I tried highlighting words instead of letters. I use the split function and compare words one by one highlighting those which aren't identical. let's see if I succeed.

Hei, I’d like to mark the difference between two text boxes. I have the following code to open and compare the text but I don’t know how to change the colour of the letter/character which is checked different. The .selcolor method and Selection.font.colorindex don’t work, the .forecolor isn’t...