[MS_AccessPros] How to get the first letter of an inputBox

 

Dear All,
How do we get the first letter of an inputbox? For example, if I type "a123", how the I get the "a"?
By the way, here's what I have tried:

Dim strInputBox As String
strInputBox = InputBox("Please enter the ID.", "")

If Left(strInputBox, 1) = "a" Then
strfrm = "frmTransaction"
strID = "TransactionID"
strFormTable = "tblTransaction"
End If

But the above code doesn't work.

Best Regards,
Kevin

Zhao LiQing

__._,_.___

---

Posted by: <zhao.liqing@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___