+ Reply to Thread
Results 1 to 3 of 3

Copying txt from 1 textbox to another OR if value formatted a certain way delete the txt

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    26

    Copying txt from 1 textbox to another OR if value formatted a certain way delete the txt

    On F_Schedule_review_wide there are text boxes called Task_Code and one named WO_Description. Everything works as it should except when the task_code value format is xxxxxxxx-xx-xx (can be numbers or letters). In most cases it is xxxxxxxx-xx. When task_code value format equals xxxxxxxx-xx-xx then I need wo_description to be blank otherwise put what it normally would which is control source wo_description. Any help is appreciated in advance.

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    IOWA
    MS-Off Ver
    2010 Professional
    Posts
    270

    Re: Copying txt from 1 textbox to another OR if value formatted a certain way delete the t

    Hi Saintsphan,
    Is this during entry or to cleanup the whole recordset?

    Example of during entry:
    AfterUpdate Event
    Using If-Then

    There are a few ways to do this, one would be if the length is fixed you could use the "Len()" function.
    Another way would be to break it into an array and check the number of items in array using "Ubound()" function.

    Since your original post is not that specific, my answer can't be either.

    Hope this helps,

    Dan
    "I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
    If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Copying txt from 1 textbox to another OR if value formatted a certain way delete the t

    Thank you for the quick reply. This is to cleanup the form. It pulls data and all the information is basically a form with all the output. I assume the answer would be placed in an afterupdate


    Quote Originally Posted by split_atom18 View Post
    Hi Saintsphan,
    Is this during entry or to cleanup the whole recordset?

    Example of during entry:
    AfterUpdate Event
    Using If-Then

    There are a few ways to do this, one would be if the length is fixed you could use the "Len()" function.
    Another way would be to break it into an array and check the number of items in array using "Ubound()" function.

    Since your original post is not that specific, my answer can't be either.

    Hope this helps,

    Dan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1