I mean I want to take the text, let's say 112223344 from one text box and
add .jpg to it, 11223344.jpg and put that into another text box.
And I want to do it automatically whenever the record is new and I enter
the 11223344 in the first text box. Entering it twice is a pain.
Keith
On Tue, 30 Sep 2008 19:48:30 -0400, "Twayne" <[EMAIL PROTECTED]>
wrote:
>> I have a form and I want one text box to be the same value as another
>> text box, but with a .jpg extension tagged on.
>
> I'm not understanding tagging a jpeg extension onto a texbox, but it
> should be as easy as a Rename? Assuming there is an object of some sort
> inthe textbox, just rename it?
>
> HTH
>
>
>>
>> I just don't know how to write the macro for it.
>>
>> Here is what I've tried so far, with no success.
>>
>> Sub frmNewProductEntry_AfterTextModified(Event as Object)
>> 'Variable Definitions:
>> Dim Form As Object
>> Dim ImageName As String
>> Dim ISBN as String
>> Dim textboxISBN as Object
>> Dim textboxImage as Object
>>
>> 'Form=ThisComponent
>> 'Form=frmNewProductEntry
>> Form=StarDesktop.CurrentComponent
>> 'If Not Form.IsNew Then Exit Sub
>>
>> textboxISBN = Form.getByName("txtproducts_model")
>> textboxImage = Form.getControl("txtproducts_model")
>> ISBN=textboxISBN.TEXT
>> ImageName=ISBN+".jpg"
>> textboxImage.TEXT=ImageName
>>
>> End Sub
>>
>> It gives me a "Property or Method Not Found" error at the line:
>> textboxISBN = Form.getByName("txtproducts_model")
>>
>> Any ideas?
>>
>> Keith
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
