Re: [MS_AccessPros] Listbox

 

I would format the date in the combo box like YYYY-MM-DD. You can see if this works by itself. If no, use the CDate() function.

Duane

Get Outlook for iOS

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Sunday, August 11, 2019 11:13:21 AM
To: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Listbox

 

Dear All,

I have a ListBox named (SelectedCodeNo) that shows 3 columns like:

ModelCode Lot# LotDate

Mdl1 1 25.10.19

Mdl2 1 13.08.18

Mdl2 2 15.09.18

Mdl3 1 20.10.17

When I click this ListBox the next code must add a date in textbox named(SelectedLot_BMWDate):

Me.SelectedLot_BMWDate = Me.SelectedCodeNo.Column(2)

I need to use (SelectedLot_BMWDate) as a date

the problem that Access see this date as a text 

how to solve this problem

thanks in advance 

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___