Results 1 to 2 of 2

Thread: [RESOLVED] How to seperate this value?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    Resolved [RESOLVED] How to seperate this value?

    I have textbox and 2 two combo box..

    In the textbox show value like this 1/2004. How I can seperate this value and show value "1" in combo1 and "2004" in combo2?


    Code:
    Text7.Text = .Fields("Musim").Value

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How to seperate this value?

    Code:
    Dim arrString() As String
    arrString = Split(Text1.Text, "/")
    Combo1.Text = arrString(0)
    Combo2.Text = arrString(1)

Posting Permissions

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



Click Here to Expand Forum to Full Width