Extract first row of button caption

[latex88]

I was somehow able to modify some codes, which I don't quite understand how I did it, but basically I used the recordset and looping methods to auto populate captions of a bunch of buttons in a form. Now I need to set an event to extract the first line of the button caption. Seems easy right? Well, not quite, at least not for me. The caption of these buttons are made up of two fields from a table and are wrapped around, meaning there are multiple lines. Part of the code looks something like this

Me(Variable).Caption = FieldName1 & chr(13) & chr(10) & FieldName2

Just to give you some more background, these buttons are populated with English on top and foreign language on the bottom. Now, I want to extract just the English part. By the way, the English may have more than one word. For example:

My name is Latex
Me llamo Latex

From the example above, I just want "My name is Latex" to return so I can pass it on to another area of the database. I hope I'm somewhat clear with my request.

 

[Beetle]

Well, we already covered this somewhat in this thread, but since you have the "first Line" of text available in a table field, why not just get it from there?

 

[latex88]

Well, we already covered this somewhat in this thread, but since you have the "first Line" of text available in a table field, why not just get it from there?

Oh my gosh. How did I not remember that? I just posted that same question for a different application and I actually did use it too. It worked quite well. I feel so embarrassed. Thank you so much for pointing the way. My face is getting redder as I type...

 

[Beetle]

No problem. I forget things quite often. Like this one time.....wait.....what were we talking about?