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

 

Dear Peter,

Thanks for your help.

Best Regards,

Kevin

发自 WPS邮箱客戶端

在 "Peter Randløv randlov@post9.tele.dk [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2019年1月17日 01:16写道：

 

Hi Kevin
The following code shows the two first letters of LBNR, which has the format AB1234:
Me.Image12.Picture = strSAMLINGdrev & Left([LBNR], 2) & "\" & [LBNR] & ".jpg"
Where strSAMLINGdrev is as path so the picture shown will be e.g. D:\RODS\SAMLING\AB\AB1234.jpg
Does it work for you?

Peter 

Den 16-01-2019 kl. 16:22 skrev Qingqing qingqinga@yahoo.com [MS_Access_Professionals]:

 

Dear All,
How do we get the first letter of an inputbox? For example, if I type "a123", how the I get the "a"? Thanks.
Best Regards,
Kevin

__._,_.___

---

Posted by: qingqinga <qingqinga@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

---

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

.

__,_._,___