Re: How do I loose 2 decimal places in a combo box
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 9 Oct 2007 17:24:13 +0800
If the combo's Row Source has more than one column, chances are that the displyed data is not what is being stored in the table. If so, you can use the Format() function in the RowSource to specify how you want the non-bound column displayed.
Example:
SELECT MemberID, Format([MemberValue], "#,##0") AS DisplayValue
FROM Table1;
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"ArkRoyal" <ArkRoyal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1201F655-5F36-4FB1-8960-085F7085A2B8@xxxxxxxxxxxxxxxx
I have set up a database for my local Credit union.
I have set the member's id number as an integer in a member table. I have
set the format as "fixed" and decimal places as 0 as an added measure.
I am using a combo box in a form bound to the members id in the members
table. I have also set the format of the box as "fixed" and decimal places
as zero. However, the combo box is displaying the id number with two decimal
places, which I am unable to get rid of. Has anybody also had this problem
and, if so, how was it resolved.
I have designed the data base for use in Access 2000 using Access 2007.
.
- Prev by Date: RE: Linked table design question
- Next by Date: RE: Linked table design question
- Previous by thread: basic design question - when to (not) update a table
- Next by thread: Re: How do I loose 2 decimal places in a combo box
- Index(es):
Relevant Pages
|
