Problems with pasting non latin characters into recordset field

[BaldPlumber]

Hi

I am having a problem with an access/VBA application that has to be written with the forms controls displayed in either English or Thai.

I have a simple language translation table that contains details if the form name, the control name and the English and Thai captions that are loaded depending on whether the user is a Thai or English speaker.

I can populate this table relatively quickly and easily just by using google translate and pasting the Thai equivalent caption into the appropriate field.

The problem is that for an odd language like Thai, it pretty much defies all attempts by google translate to come up with anything that makes one iota of sense, unless the caption is just a single word.

So, I thought I would make like easier for the users of the system to be able to update the global translation fields via a popup form that loads the existing definitions for all controls for any given form and also loads just the English captions for those that are missing definitions, in order to allow the users to make sure that the translated form actually makes sense.

This all works fine if they are using a thai keyboard but I have noticed that if I try and paste a string of Thai characters into a field it causes a carriage return. No amount of trimming is so far able to remove this. Worse, I can't even see what the character is as my watch window seems to be lacking the view hexadecimal option.

I can remove the CR from the definitions table later, bu this is very annoying to have to do.

This wouldn't be a problem for a Thai user as they are hardly going to use translate to provide thai definitions, but for me, developing the thing it i a quick and easy way of coming up with something.



I have attached a screen shot which probably explains what I am trying to do better than I have done so far.

I'd be grateful for any advice.

Thanks
Mike

[rpeare]

before you save the changes use Fieldname = trim(fieldname) for every field on your form that has a value, that should remove any 'invisible' characters like a carriage return, line feed, etc.