Re: [MSAccessProfessionals] decimals not to show on drop down list

Hi Khalid,

You never responded to my previous question to you:

==============================================

"Is there still an issue? Your reply just provides code with out any status regarding your question. Also, you haven't included any part of the previous thread in your reply. It always helps to include previous messages.

If it doesn't work, I would add this line

  stLinkCriteria = "[TripNo]=" & SID

  debug.Print stLinkCriteria      'open the debug window to view this

==============================================

I would like to get an answer and then address this question.

Also what have you tried in order to set the format in the combo box display?

What is the Row Source of the combo box?

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Khalid Tanweer via Groups.Io <khalidtanweerburrah=yahoo.com@groups.io>
Sent: Friday, January 24, 2020 1:54 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] decimals not to show on drop down list

 

Hi all,

Tbl CST has PK TripNo, Long Integer,Standard. decimal places zero.

on a form  'Cst Expenditures' is a combo box CstName unbound, when i click it on drop down list of CstName it shows

CstName (Labelled Trip No) with two decimal places,

after selecting any from the list combobox CstName the value is shown rounded, how do i stop decimal places in list.

 

Please help.

Regards Khalid