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

Regarding the previous thread, "Duplication of entry..." you had stated "Sorry for botheration, the code is now as:". Then I had asked if your question was resolved which you didn't reply to. Perhaps you meant to suggest it was resolved and I just didn't understand and needed confirmation which I didn't get. Maybe it's a language or culture difference.

No matter what I tried, I can't get the combo box to display decimal places even if I attempt to format the column in the design of the Row Source. You could try concatenate a zero length string to the TripNo column making it TripNo & "".

Khahlid said:
For my current question nothing is set in combo box display, Format--> Blank, decimal places=0,visible=Yes, Column Count=3
Row source of combo box is:
Under date tab tabm Row source is:
SELECT CST.TripNo, CST.CstName, CST.SegmentNo FROM CST ORDER BY CST.TripNo;
Bound Column=1, Limit to list = Yes
I'm available full time, waiting for any suggestion and pointing out my mistake.
Regards & thanks,
Khalid

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115415) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_